Is there a way to not have #value! show in a call?
F fooreest Jan 11, 2010 #3 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
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
G Gord Dibben Jan 11, 2010 #4 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
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
