mark up

[arKwelder]

need to mark up 16800 items by 15% column e is my net and need column f
with new prices

 

[Eduardo]

opps you will enter 0.15 instead of 15

Hi,
in column F enter

=E2*1.15

copy formula down

you can have a cell where you enter the markup % like A1, then have F
calculate it using

=E2*(1+A1)

in A1 you will enter 15

 

[David Biddulph]

.... and you may want =E2*(1+A$1) instead of =E2*(1+A1), if you are going to
copy down.