Make a decimal number return to zero
On Wednesday, October 19, 2016 at 10:36:20 AM UTC-7, wrote:
I am looking to make a decimal number return to zero. Example
if AI EQUALS 37.5
I want to do a formula that divides AI by 2 and when it comes out to 18.75
which is not a whole number then it should state the cell as zero if it is
a whole number then it would return the whole number to that cell.
Maybe something like this:
=IF((A1/2) = INT(A1/2), A1/2, 0)
|