| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to return 1 with #VALUE!?
You can use the function ERROR.TYPE to only check for #VALUEs:
=IF(ERROR.TYPE(<YourFormula)=3,1,<YourFormula) Altho all the caveats made by JE McGimpsey re masking genuine errors still apply - you'll just have excluded the other error types. Hope this helps! Richard Eric wrote: Does anyone know how to return 1 with #VALUE!? Thank for any suggestion Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with index to return particular cell value | Excel Discussion (Misc queries) | |||
| annualized return calculation for the purpose of portfolio performance evaluation | Excel Worksheet Functions | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
| check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
| How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
Threaded Mode
