How do I test cell for a whole integer (non fractional) and return the value if it is and a blank if not?

calc
math

asked 2018-06-01 23:10:15 +0100

horizon69
11 ●1 ●1 ●2

Have a Series of cells with a formula. I would like to hide and/or return a blank on any cell that less than or more than a whole number. (example .5, 1.25, etc. would not be shown, but 2, 4, etc. would be.

Ps It's been 10yrs since attempting to program. I hope this helps, Thank You

edit retag flag offensive close merge delete

add a comment

2

answered 2018-06-02 01:26:22 +0100

Lupp
10948 ●24 ●81 ●149

Hopefully the Original Questioner is aware of the fact that trusting in computers with this kind of questions comes with risks.

It heavily depends on the kind of "a formula" if its result will be exact enough to allow for distinguishing between integer and non-integer results reliably as needed.

See this attached example.