Showing only actual natural un-rounded full integers

  • Thread starter Thread starter Harry James
  • Start date Start date
H

Harry James

Hi --

I am trying to create a method of instructing a range of cells (60 columns x
8 rows) to only show a resulting number from a formula if it is a totally
whole number. I do not want to use any formula results if it contains any
fractional results whatsoever.

In the rows where I have entered formulas to show "resulting" new home
sales, I want to create a method that will hide any formula results that
contain a fraction. I only want to show any non-rounded results that result
in a whole number, and I do not want any form of rounding to take place at
any time.

I have tried the following basic (and many variations of this) formula:

IF(D83=<>INT," ",D83)

I usually get #ERROR (or some other error message, #NAME, ect.) messages -
or, worst yet, a rounded result.

I have also tried to use some variations of conditional formatting to
accomplish this but, so far, no luck. Additionally, I have looked for a
symbol (or some other indicator, instruction or icon to tell Excel not to
round any resulting number) that would pertain to an un-rounded whole number
only to try in some conditional formatting instructions, but I have not been
able to locate one. Is there such a thing?

Does anyone know how I can accomplish this goal?

Thanks for any help that you can give me.

Harry
(e-mail address removed)
 
I read it that the OP wanted the formula to hide itself. If that is the
question then

=IF(SUM(A83:D83)<>INT(SUM(A83:D83)),"",SUM(A83:D83))

will only show the result for a whole number. Of course if the data is
itself the result of other formulas then it may be necessary to round within
my formula to prevent binary errors. However, any subsequent formula using
the results of the above formula except another SUM will probably choke on
the "" text.

A Conditional Formatting formula of

=D82<>INT(D83)

with both the Font and Cell Shading set to white will hide the results in
the cell.

With Conditional Formatting the value will still be in the cell so any
subsequent formulas including SUM will use the value even although it is not
visible which may not be what the OP wants.

Regards

Sandy
 
Back
Top