making excel more error tolerant

Brass Contributor

This is the idea =IFERROR(FIELDVALUE($A2,B$1),"").

 

I was wondering how I can make every col tolerant

 

Things like =IF(AND(J2>0, K2>0), J2*K2,0) this eliminate some problems

 

Then =IF(OR(K2=0,L2=0), 0, summary!$B$16/L2-C2)

 

Lots of fun

 

one column has stockhistory and somw cells show FIELD error etc

1 Reply