To change a number as it's being used in a formula:

A1 = 10.25
B1 = 10
=A1*B1
Returns - 102.5

Revise to:
=INT(A1)*B1
Returns - 100


To change the return of a formula:
=INT(A1*B1)
Returns - 102
--

HTH,

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

--

HTH,

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

"Mustang" wrote in message
...
I have a formula that derives the answer from a figure with a decimal. I
don't want to use the figures after the decimal. Is there a way to just use
the whole number and omit the numbers after the decimal without having to
manually key in all these numbers manually?

Thanks,
Mustang