| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Testing for an Integer result in a formula
I'm writing a nested IF statement in which one step needs to test the value
of one cell divided by another cell, and determine if it is an integer before it completes the calculation. So, IF cell R10 / I13 = INTEGER, then I'll perform a Future Value calc. IF NOT = I want to do nothing. I tried ISEVEN, but when I turned on the Analysis Took Pak nothing happened. My spreadsheet still did not recognize the ISEVEN. Suggestions please? -- Jerry G |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I round a formula result to the next integer? | Excel Worksheet Functions | |||
| Need Formula to calculate n*'cell value' where n is any integer | Excel Discussion (Misc queries) | |||
| Testing the results of a formula for zero | Excel Discussion (Misc queries) | |||
| Testing for existence of a formula | Excel Worksheet Functions | |||
| Check if result is an integer? | Excel Worksheet Functions | |||
![JerryG[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
