how to muliply

S

S S

Brain must be frzzled tonight.............

How do I take 240 and multiply it by 33%

=d3 *33% (d3 is the 240)

I know its wrong what is it??
 
B

Bob Phillips

That looks correct to me. Why do you think it is wrong?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
B

Bob Phillips

If it because you get 79.2 not 80, try either

=D3*33.3333333333%

or even

=ROUND(D3*33.3333%,0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
S

S S

Aha I want to add on 33%

so 240 plus 33% should be 320, its giving me 80 as 33% only of 240

ok if not 100% I can round up.
 
Top