Thread: mark up
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default mark up

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


"Eduardo" wrote in message
...
opps you will enter 0.15 instead of 15


"Eduardo" wrote:

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

"arKwelder" wrote:

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