Forum Discussion
making excel more error tolerant
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
First some knowledge:
Use IFERROR().
