| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#VALUE!
Is there a way to not have #value! show in a call?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE!
=IF(ISERROR(YourFormula),"",YourFormula)
-- Kind regards, Niek Otten Microsoft MVP - Excel "dwolf" wrote in message ... Is there a way to not have #value! show in a call? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE!
OR
Page Setup / Sheet / Cell errors as: (choose blank; default is displayed) - this is only for printing pages (error is not displayed) - IF(ISERROR) for hide message "error" when sheet is displayed "dwolf" wrote in message ... Is there a way to not have #value! show in a call? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#VALUE!
Trap for data that would create the error in the first place.
Elsewise =IF(ISERROR(D1*F1),"",D1*F1) in 2007 =IFERROR(D1*F1,"") Gord Dibben MS Excel MVP On Mon, 11 Jan 2010 10:22:03 -0800, dwolf wrote: Is there a way to not have #value! show in a call? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
