| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |
|
|
Hybrid Mode
