| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Recognizing Unstable Values in Excel
I apologize if someone already saw or answered this question ... I can't find
which subcategory of Excel groups where it apparently was posted earlier. My question is how can you write an if then statement that recognizes that the cell has an unstable answer. When I use the statement, IF(A1="#DIV/0!",1), the cell doesn't return the value of "1" when the values are unstable. How would I do this? -- Ken |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table not recognizing same field values | Excel Discussion (Misc queries) | |||
| Excel 2002: Unstable colour settings | Excel Discussion (Misc queries) | |||
| Recognizing Real Values | Excel Discussion (Misc queries) | |||
| Excel not recognizing equal values | Excel Worksheet Functions | |||
| Excel 97 unstable | Setting up and Configuration of Excel | |||
Threaded Mode
