| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I avoid repeating calculation in IF function?
I use a calculation that sometimes (legitimately) returns the error code
#N/A. When this happens, I want a blank stored in the cell. So: IF(ISNA(calculation),"",calculation) Is there some way of avoiding the second calculation? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| avoid nested IFs with another function | Excel Worksheet Functions | |||
| can i avoid repeating rows when adding calculated item in pivot ta | Excel Worksheet Functions | |||
| Make unique cells - Avoid repeating Values | Excel Discussion (Misc queries) | |||
| How do you avoid duplicates when using the randbetween function? | Excel Worksheet Functions | |||
| Avoid geeting function GETPIVOTDATA | Excel Discussion (Misc queries) | |||
Threaded Mode
