How do I mark-up prices by 25% in Excel?

by

I have a prices in column “A” that I need to add 25% to and output in column “B”.

Any ideas ?

3

✅ Answers

🥇 Favorite Answer

  • in column B1 (or whatever row to start in) type:

    =A1*1.25

    Then FILL DOWN to fill out the rest of the rows.

  • Example for cell B1

    =A1*1.25

    Once you have two or three of them, you can drag down the bottom right corner box of the cell and it will replicate the formula but change the values to match each row you’re in. This would save you from having to type it out hundreds of times.

  • In cell b1 type this formula:

    =a1*1.25

    Copy and paste the formula down for all other appropriate rows.

    Edit: Misc Tech Advice beat me by ten seconds. Good work. I’ll have to type faster next time.

    • Leave a Comment