Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
test expression for empty cell in =SUMIF() | Excel Worksheet Functions | |||
How to return the row # of an expression in specific array of cell | Excel Worksheet Functions | |||
need help with expression | Excel Discussion (Misc queries) | |||
Expression | New Users to Excel | |||
Conditional Expression in cell | Excel Worksheet Functions |