Variance column to be zero

[Mile129]

I have a query with variance columns from the data in the other columns, I want to put a formula in the variance coulmn to return a zero if it is less than 1, it can be either a -1 or +1. If it is less than that, I would like a zero instead of a decimal place. I would like to retain the decimal places for over 1 variances. Please advise if this is possible. Thanks.

[weekend00]

Please check IIF function.

[Mile129]

That will work, but how do I say the absolute of 1, either +1 or -1? Basically if the absolute value of column A minus column B is less than 1, enter zero.

[Mile129]

I got it, I put ABS in front of my formula, thanks Weekend00 for the IIF statement.

[weekend00]

My pleasure I can help a little.