View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default Sales mark up formula

Make that:

=(C2+100)*1.38

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
Saying:

using =C2+100*0.38 . That didn't work.


is not very helpful. What didn't work?

I assume that you mean add $100 and then times the total of the original
price Plus the $100 by38%. If so try:

=(C2+100)*.38

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Mike Banner" <Mike
wrote in message
...
Can anyone help a newbie?

I have a problem creating a formula for sales mark up. I have the base
cost
in colum c and need to add $100.00 for installation and times 38%? I
tried
using =C2+100*0.38 . That didn't work.

Any suggestions would be most helpful. Thank you in advance.