Thread: how to muliply
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default how to muliply

=d3*(1.33333)



"S S" wrote:

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.


"Bob Phillips" wrote in message
...
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" wrote in message
...
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??