ISERROR

  • Thread starter Thread starter Dave
  • Start date Start date
D

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.
 
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
 
Hi Dave
then i would use the follwoing:
IF(U12,U12,IF(ISERROR(X12),"error in X12",X12))
 
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
 
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
 
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
 
Back
Top