| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.worksheet.functions
|
|||
|
|||
|
How to return 1 with #VALUE!?
See one answer in microsoft.public.excel.misc
Please don't post the same message to multiple groups. It just tends to fragment any answers, and it potentially wastes the time of those answering questions that have already been answered. In article , Eric wrote: Does anyone know how to return 1 with #VALUE!? Thank for any suggestion Eric |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to return 1 with #VALUE!?
Check your other post.
Eric wrote: Does anyone know how to return 1 with #VALUE!? Thank for any suggestion Eric -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to return 1 with #VALUE!?
=IF(ISERROR(your formula),1,your formula)
"Eric" wrote: Does anyone know how to return 1 with #VALUE!? Thank for any suggestion Eric |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Thank everyone for suggestion
Thank everyone for suggestion
|
| 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 | |||
Hybrid Mode
