Formula without using numbers after decimal in the answer

[Guest]

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

 

[swatsp0p]

You can use the INT function. This 'rounds down' any number to th
nearest integer, e.g. if A1=2.567, a formula in B2 of =INT(A1) return
2

HTH

Bruc

 

[Guest]

You are correct. It is much easier to fix a formula and copy it than to
re-type piles of numbers.

Say you have 123.456 in A1 and your formula looks like

=A1+.......

replace A1 with FIXED(A1,0) and copy it anywhre you want.

 

[RagDyeR]

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

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

 

[Guest]

That worked! Thanks!!!!!

You are correct. It is much easier to fix a formula and copy it than to
re-type piles of numbers.

Say you have 123.456 in A1 and your formula looks like

=A1+.......

replace A1 with FIXED(A1,0) and copy it anywhre you want.

 

[RagDyeR]

You *are* aware, that the return of the FIXED() function is *text*, and
*not* a number.