The Student Room Group

excel formulas

hey peeps, i realise this isnt the computing section but it has a little to do with maths lol! i was hoping someone could help me

in excel i need a formula to represent the following

i need to dictate a mark up price of vegetables (for profit) then the resale price per vegetable = wholesale price + mark up% of wholesale price

the formula would look something like

B9 =B20 + x% of B20

anyone no how to write this properly in excel? lol i have no idea how to even declare x in the first place?
Reply 1
In cell B9 write

=B20+(B20*x%)

If you want the percent in a seperate box, say Y1 put


=B20+(B20/100*Y1)

Latest

Trending

Trending