| 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 | |||
Hybrid Mode
