| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if value equals whole number then ...
I need to write a conditional statement that does the following:
If the result of <formula = a whole number, then <formula2, else <formula3 I have all the formulas working I just don't know how to writeup that first condition, if the resulting value of the formula is a whole number then do this, else that. Pls help, thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| equals the actual number...not text ???? | Excel Worksheet Functions | |||
| assign a number value to a text. ie, PL equals .5 | New Users to Excel | |||
| how to run a macro when a calculation equals a certin number | Excel Worksheet Functions | |||
| Entered text value equals a number I specify in another cell | Excel Worksheet Functions | |||
| custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) | |||
Threaded Mode
