#n/a

  • Thread starter Thread starter BannerBrat
  • Start date Start date
B

BannerBrat

I have values that continues to change, sometimes I get a return #N/A.
Is it possible to change the formula to have the returned value #N/
changed to 0 (zero)? I need help!
Thank
 
You don't mention your formula so I have to give a generic answer which you
will have to adapt to your formula's.

IF(ISNA(Your formula),0,Your Formula)

If your formula generates #N/A , the ISNA function generates TRUE and
therefore the output of the IF becomes 0.
If your formula gives a "normal" value the ISNA function returns FALSE and
the IF generates the result of the (second) Your Formula

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top