Multiplying by Whole Numbers

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

 

[Max]

Assuming source numbers in B2 down,
you could use the integer part of it in C2 as eg: =INT(B2)

 

[Drake]

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.

 

[Gord Dibben]

=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.

 

[Ragdyer]

Just use Round().

=Round(B2,0)
Or
=Round(your formula,0)

 

[Gord Dibben]

Too simple<g>


Gord

 

[Drake]

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.

 

[Gord Dibben]

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

 

[Ragdyer]

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

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

 

[Drake]

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.

 

[Gord Dibben]

Ah so.........

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

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


Gord

 

[RagDyeR]

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