Thread: mark up
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default mark up

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