ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how to muliply (https://www.excelbanter.com/excel-worksheet-functions/152309-how-muliply.html)

S S

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



Bob Phillips

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




Bob Phillips

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




S S

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






Toppers

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







S S

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










All times are GMT +1. The time now is 02:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com