ISERROR

[Dave]

I need to include the ISERROR function into
=IF(U12,U12,X12)
so it will not return #N/A or #VALUE!.
Any ideas?
Thanks for all of the help in the past.

 

[Frank Kabel]

Hi Dave

which part of your function can return #N/A or #VALUE: U12 and/or X12
depending on that you can create an IF function: e.g.
=IF(ISERROR(IF(U12,U12,X12),"error in function",IF(U12,U12,X12)))

HTH
Frank

 

[Dave]

The error is from the results of X12

Tanks Frank

 

[Frank Kabel]

Hi Dave
then i would use the follwoing:
IF(U12,U12,IF(ISERROR(X12),"error in X12",X12))

 

[Dave]

I tried IF(U12,U12,IF(ISERROR(X12),"error in X12",X12))
and =IF(U12,U12,IF(ISERROR(X12),"error in X12",X12))
they both show up as text and not a formula

thanks Frank

 

[Frank Kabel]

Hii Dave
sorry, i forgot the '=' in my last post. Including it, the formula
should work (maybe the cell is´formated as text). Goto 'Format - Cell'
and set the format to general. After that reenter the formula. should
work


Frank

 

[Dave]

Hi Frank

I formated the cell as general and it still shows as text. It was formated
as numbed with 2 decimal places

I used =IF(U12,U12,IF(ISERROR(X12),"error in X12",X12))

Thanks Again