how to muliply

[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??

 

[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)

 

[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]

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.

 

[Guest]

=d3*(1.33333)

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.

 

[S S]

ok thanks got it now

=d3*(1.33333)