Sales mark up formula
 

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.

Sales mark up formula
 

Maybe this:

=C2+100+(100*0.038)

HTH,
Paul

--

"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.

Sales mark up formula
 

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.

Sales mark up formula
 

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






--

"PCLIVE" wrote in message
...
Maybe this:

=C2+100+(100*0.038)

HTH,
Paul

--

"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.

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.

Sales mark up formula
 

If you want to add your $100, and then *increase* the *total* by 38%, try
=(C2+100)*(1+38%)
--
David Biddulph

"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.