ExcelBanter - #VALUE!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - #VALUE! (https://www.excelbanter.com/excel-discussion-misc-queries/252990-value.html)

dwolf

#VALUE!

Is there a way to not have #value! show in a call?

Niek Otten

#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?

fooreest

#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?

Gord Dibben

#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?

All times are GMT +1. The time now is 10:13 AM.