what should be simple
Either you can modify the formulas in g2,o2,w2,ae2 to handle the error.
Instead of =S2/V9 modify that to =IF(COUNT(S2,V9)=2,S2/V9,"")
OR use the below formula to return MIN() . Please note that this is an array
formula. You create array formulas in the same way that you create other
formulas, except you press CTRL+SHIFT+ENTER to enter the formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula}"
=MIN(IF((MOD(COLUMN(G2:AE2)+1,8)=0)*(ISNUMBER(G2:A E2)),G2:AE2))
--
Jacob (MVP - Excel)
"Rene" wrote:
b2 =min(g2,o2,w2,ae2)
g2 =k2/n2
o2 =s2/v9
...
b2 works when all the cell formulas have data to compute, but does not work
when one of the formulas returns the error msg #div (no data)
Thanks for your help
|