How do I ignore any fractions?

[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,
(e-mail address removed)

 

[Andy Brown]

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.

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

 

[Andy B]

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