C
Connie Martin
I have this formula in L20 that works one place and not the other:
=IF(F20=0,"",IF(F20=1,1,AVERAGE(IF(F15:F19<>0,F15:F19))))
On one worksheet the number in F20 is 1, and it gives 1 in L20 with this
formula, but in another worksheet, the number is 11 in F20, and I get #VALUE!
in L20.
What is the reason?
Connie
=IF(F20=0,"",IF(F20=1,1,AVERAGE(IF(F15:F19<>0,F15:F19))))
On one worksheet the number in F20 is 1, and it gives 1 in L20 with this
formula, but in another worksheet, the number is 11 in F20, and I get #VALUE!
in L20.
What is the reason?
Connie