| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to muliply
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?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to muliply
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) "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?? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to muliply
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?? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to muliply
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?? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to muliply
ok thanks got it now
"Toppers" wrote in message ... =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?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a formula to muliply hours times dollars per hour? | Excel Discussion (Misc queries) | |||
| A formula that is: if the sum is this, then muliply by this? | Excel Worksheet Functions | |||
| muliply | New Users to Excel | |||
Linear Mode
