How do I ignore any fractions?

  • Thread starter Thread starter hardlook
  • Start date Start date
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,
(e-mail address removed)
 
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
 
Another option is to chop off the numbers after the decimal point by using
the INT() function.
 
Back
Top