Forum Discussion
Hedge_Fund_Manager
Nov 11, 2022Brass Contributor
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=...
Detlef_Lewin
Nov 14, 2022Silver Contributor
First some knowledge:
Use IFERROR().