Use the =MOD() function.

For example if =MOD(A1,9) is zero then A1 can be divided evenly by 9
--
Gary''s Student - gsnu200750


"DavidJ" wrote:

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