Multiplying by Whole Numbers

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
Sun Nov 11 01:36:35 PST 2007

Assuming source numbers in B2 down,
you could use the integer part of it in C2 as eg: =INT(B2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Drake" <Drake@Drake37.org> wrote in message
news:4fidj35je6414o0eb21us42f3ohiibsovi@4ax.com...
>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?

Drake
Sun Nov 11 13:27:42 PST 2007

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.

On Sun, 11 Nov 2007 17:36:35 +0800, "Max" <demechanik@yahoo.com>
wrote:

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

Gord
Sun Nov 11 13:32:50 PST 2007

=INT(ROUND(B2,0))


Gord Dibben MS Excel MVP

On Sun, 11 Nov 2007 13:27:42 -0800, Drake <Drake@Drake37.org> wrote:

>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.
>
>On Sun, 11 Nov 2007 17:36:35 +0800, "Max" <demechanik@yahoo.com>
>wrote:
>
>>Assuming source numbers in B2 down,
>>you could use the integer part of it in C2 as eg: =INT(B2)

Ragdyer
Sun Nov 11 13:45:01 PST 2007

Just use Round().

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Drake" <Drake@Drake37.org> wrote in message
news:7psej3pbl4ed864e2l1esagssm1u0ijr8g@4ax.com...
> 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.
>
> On Sun, 11 Nov 2007 17:36:35 +0800, "Max" <demechanik@yahoo.com>
> wrote:
>
> >Assuming source numbers in B2 down,
> >you could use the integer part of it in C2 as eg: =INT(B2)
>

Gord
Sun Nov 11 13:52:12 PST 2007

Too simple<g>


Gord

On Sun, 11 Nov 2007 13:45:01 -0800, "Ragdyer" <RagDyer@cutoutmsn.com> wrote:

>Just use Round().
>
>=Round(B2,0)
>Or
>=Round(your formula,0)

Drake
Sun Nov 11 14:20:14 PST 2007

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.

On Sun, 11 Nov 2007 13:52:12 -0800, Gord Dibben <gorddibbATshawDOTca>
wrote:

>Too simple<g>
>
>
>Gord
>
>On Sun, 11 Nov 2007 13:45:01 -0800, "Ragdyer" <RagDyer@cutoutmsn.com> wrote:
>
>>Just use Round().
>>
>>=Round(B2,0)
>>Or
>>=Round(your formula,0)

Gord
Sun Nov 11 14:25:45 PST 2007

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

On Sun, 11 Nov 2007 14:20:14 -0800, Drake <Drake@Drake37.org> wrote:

>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.
>
>On Sun, 11 Nov 2007 13:52:12 -0800, Gord Dibben <gorddibbATshawDOTca>
>wrote:
>
>>Too simple<g>
>>
>>
>>Gord
>>
>>On Sun, 11 Nov 2007 13:45:01 -0800, "Ragdyer" <RagDyer@cutoutmsn.com> wrote:
>>
>>>Just use Round().
>>>
>>>=Round(B2,0)
>>>Or
>>>=Round(your formula,0)

Ragdyer
Sun Nov 11 14:43:22 PST 2007

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" <gorddibbATshawDOTca> wrote in message
news:d30fj3te6ovmn9ghutuv3ju2v9rirskedm@4ax.com...
> 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
>
> On Sun, 11 Nov 2007 14:20:14 -0800, Drake <Drake@Drake37.org> wrote:
>
> >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.
> >
> >On Sun, 11 Nov 2007 13:52:12 -0800, Gord Dibben <gorddibbATshawDOTca>
> >wrote:
> >
> >>Too simple<g>
> >>
> >>
> >>Gord
> >>
> >>On Sun, 11 Nov 2007 13:45:01 -0800, "Ragdyer" <RagDyer@cutoutmsn.com>
wrote:
> >>
> >>>Just use Round().
> >>>
> >>>=Round(B2,0)
> >>>Or
> >>>=Round(your formula,0)
>

Drake
Sun Nov 11 19:19:05 PST 2007

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.


On Sun, 11 Nov 2007 14:25:45 -0800, Gord Dibben <gorddibbATshawDOTca>
wrote:

>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
>
>On Sun, 11 Nov 2007 14:20:14 -0800, Drake <Drake@Drake37.org> wrote:
>
>>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.
>>
>>On Sun, 11 Nov 2007 13:52:12 -0800, Gord Dibben <gorddibbATshawDOTca>
>>wrote:
>>
>>>Too simple<g>
>>>
>>>
>>>Gord
>>>
>>>On Sun, 11 Nov 2007 13:45:01 -0800, "Ragdyer" <RagDyer@cutoutmsn.com> wrote:
>>>
>>>>Just use Round().
>>>>
>>>>=Round(B2,0)
>>>>Or
>>>>=Round(your formula,0)

Gord
Mon Nov 12 07:47:33 PST 2007

Ah so.........

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

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


Gord

On Sun, 11 Nov 2007 19:19:05 -0800, Drake <Drake@Drake37.org> wrote:

>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.
>
>
>On Sun, 11 Nov 2007 14:25:45 -0800, Gord Dibben <gorddibbATshawDOTca>
>wrote:
>
>>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
>>
>>On Sun, 11 Nov 2007 14:20:14 -0800, Drake <Drake@Drake37.org> wrote:
>>
>>>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.
>>>
>>>On Sun, 11 Nov 2007 13:52:12 -0800, Gord Dibben <gorddibbATshawDOTca>
>>>wrote:
>>>
>>>>Too simple<g>
>>>>
>>>>
>>>>Gord
>>>>
>>>>On Sun, 11 Nov 2007 13:45:01 -0800, "Ragdyer" <RagDyer@cutoutmsn.com> wrote:
>>>>
>>>>>Just use Round().
>>>>>
>>>>>=Round(B2,0)
>>>>>Or
>>>>>=Round(your formula,0)

RagDyeR
Mon Nov 12 08:05:58 PST 2007

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
news:8atgj31793soobnsa5pdkaf30sj41i0et2@4ax.com...
Ah so.........

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

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


Gord

On Sun, 11 Nov 2007 19:19:05 -0800, Drake <Drake@Drake37.org> wrote:

>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.
>
>
>On Sun, 11 Nov 2007 14:25:45 -0800, Gord Dibben <gorddibbATshawDOTca>
>wrote:
>
>>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
>>
>>On Sun, 11 Nov 2007 14:20:14 -0800, Drake <Drake@Drake37.org> wrote:
>>
>>>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.
>>>
>>>On Sun, 11 Nov 2007 13:52:12 -0800, Gord Dibben <gorddibbATshawDOTca>
>>>wrote:
>>>
>>>>Too simple<g>
>>>>
>>>>
>>>>Gord
>>>>
>>>>On Sun, 11 Nov 2007 13:45:01 -0800, "Ragdyer" <RagDyer@cutoutmsn.com>
>>>>wrote:
>>>>
>>>>>Just use Round().
>>>>>
>>>>>=Round(B2,0)
>>>>>Or
>>>>>=Round(your formula,0)