ExcelBanter - value of a cell / expression is a whole number

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - value of a cell / expression is a whole number (https://www.excelbanter.com/excel-worksheet-functions/162591-value-cell-expression-whole-number.html)

DavidJ

value of a cell / expression is a whole number

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

Gary''s Student

value of a cell / expression is a whole number

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

All times are GMT +1. The time now is 08:34 AM.