Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to return 1 with #VALUE!?
Does anyone know how to return 1 with #VALUE!?
Thank for any suggestion Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to return 1 with #VALUE!?
One way:
=IF(ISERROR(<your formula), 1, <your formula) In XL2007: =IFERROR(<your formula,1) However, it's generally bad practice to do so unless that error is expected and not easily avoidable. Using either of the above formulae will also mask other errors. One can usually identify the conditions that would cause the error and prevent them. In article , Eric wrote: Does anyone know how to return 1 with #VALUE!? Thank for any suggestion Eric |
#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 |
Reply |
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 |