Multiplying by Whole Numbers

  • Thread starter Thread starter Drake
  • Start date Start date
D

Drake

I have a number in a cell that is the result of a formula. The number
doesn't come out even such as 44.44 or 56.66

I need to use this number in another formula, but I want to use the
whole number (44, 56) not the decimal version.

Is there a way I can do that?
 
Assuming source numbers in B2 down,
you could use the integer part of it in C2 as eg: =INT(B2)
 
Thanks, this will work except I need one more thing. I need to round
off the number I'm using first and then use that interger.

For example, As a result of the formula I have 55.56 and 44.44. To
go forward I want to multiply by 56 and 44. Is that possible?

Thanks.
 
=INT(ROUND(B2,0))


Gord Dibben MS Excel MVP

Thanks, this will work except I need one more thing. I need to round
off the number I'm using first and then use that interger.

For example, As a result of the formula I have 55.56 and 44.44. To
go forward I want to multiply by 56 and 44. Is that possible?

Thanks.
Click to expand...
 
I agree it's too simple. I entered "rounding off" into the help
wizard and the "round" function didn't show up. If you just enter
"round" it does.

I guess they need a help file for the help file.

Thanks again though, it's much appreciated.
 
I enter "rounding off" into the help wizard and get 20 hits.

The first hit is "round a number" which explains how to use the various ROUND
functions.

Hit 12 is "ROUND worksheet function"


Gord
 
I'm on an XL97 machine today, and didn't even get to the "... ing off" part!
While typing "round" gave "Round Worksheet Function",
And finishing with the ...ing,
Gave "Rounding Numbers".

BUT, I guess we all do know ... the older the version, the better the HELP
files!<bg>
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
Gord Dibben said:
I enter "rounding off" into the help wizard and get 20 hits.

The first hit is "round a number" which explains how to use the various ROUND
functions.

Hit 12 is "ROUND worksheet function"


Gord

I agree it's too simple. I entered "rounding off" into the help
wizard and the "round" function didn't show up. If you just enter
"round" it does.

I guess they need a help file for the help file.

Thanks again though, it's much appreciated.

Too simple<g>


Gord
Click to expand...
Click to expand...
Click to expand...
 
When I enter rounding off I get

add a curve
Mround worksheet function
Int worksheet function
remove one or more level of tracer arrows
etc.
etc.

Nothing about rounding off or the round function.

I'm not doubting you guys at all, that's just what I see.

I'm using Office 2000.
 
Ah so.........

I am using 2003. Help is not consistent across versions.

Now.....that's an understatement<g>


Gord
 
On an XL02 machine this morning.

The HELP index keyword box *doesn't* even allow me to type "rounding"!

It stops at "round",
And displays the 3 common round functions:
Round()
Roundup()
Rounddown()

So XL02 isn't too bad in this case.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
Ah so.........

I am using 2003. Help is not consistent across versions.

Now.....that's an understatement<g>


Gord
 
Back
Top