value of a cell / expression is a whole number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use the =MOD() function.

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