value of a cell / expression is a whole number

D

DavidJ

I want to check if the value of a cell divided by a constant is a whole
number or integer - can anyone help

Thanks

DavidJ
 
G

Gary''s Student

Use the =MOD() function.

For example if =MOD(A1,9) is zero then A1 can be divided evenly by 9
 
Top