When working with a formula at returns a #N/A I would like it to display a "0" instead
D DarnTootn Mar 31, 2006 #1 When working with a formula at returns a #N/A I would like it to display a "0" instead
P Peo Sjoblom Mar 31, 2006 #2 =IF(ISNA(formula),0,formula) -- Regards, Peo Sjoblom http://nwexcelsolutions.com
D DarnTootn Apr 4, 2006 #4 Thank you for your help... it works for me... can't believe I had forgotten that formula... anywho, thanks again
Thank you for your help... it works for me... can't believe I had forgotten that formula... anywho, thanks again
