Sales mark up formula

  • Thread starter Thread starter Mike Banner
  • Start date Start date
M

Mike Banner

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.
 
Saying:
using =C2+100*0.38 . That didn't work.
Click to expand...

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Oops! I had an extra zero in there.

If you want to add C2 plus 100 plus 38% of that 100:
=C2+100+(100*0.38)
or
=SUM(C2,100,(100*0.38))

If you want to add 38% to the entire total of C2 + 100:
=C2+100+(C2+100)*0.38
or
SUM(C2+100,(C2+100)*0.38)

If you only want to know what 38 percent of the total is:
=(C2+100)*0.38

HTH,
Paul






--
 
Make that:

=(C2+100)*1.38

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
If you want to add your $100, and then *increase* the *total* by 38%, try
=(C2+100)*(1+38%)
 
Back
Top