Nov 11 2022 11:08 AM
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
Nov 14 2022 01:13 PM
First some knowledge:
Use IFERROR().