How do I ignore any fractions?

H

hardlook

Hi--
I have 8 rows of 60 columns of formulas. How do I construct these so that
no resulting answers that contain any fractions will be shown? I do not
want any rounding whatsoever - just any resulting absolute whole numbers.

Thanks,
[email protected]
 
A

Andy Brown

hardlook said:
Hi--
I have 8 rows of 60 columns of formulas. How do I construct these so that
no resulting answers that contain any fractions will be shown? I do not
want any rounding whatsoever - just any resulting absolute whole numbers.
Click to expand...

I don't know what you mean by "will be shown". If you want non-integer
results hidden from sight, try conditional formatting. If you want the
integer (rounded) results to display without using ROUND* functions, format
the relevant cells as Number with 0 DPs. Finally, there's a "Precision as
displayed" option via Tools -- Options -- Calculation, but approach it with
caution (something about it changes the value of your data permanently).

HTH,
Andy
 
A

Andy B

Another option is to chop off the numbers after the decimal point by using
the INT() function.
 
Top