Ignore #N/A in formula
Thanks for getting back to me.
The formula you posted only displays a result if there isn't an #N/A
anywhere in the formula, I want the result excluding the n/a ie if A2
= #N/A ; A3 = 1 ; B2 = 3 ; B3 = 2 and A1 = 2 i want the result ((#N/
A*1)+(3*2))/2 to equal 3 not a blank, so in essence I want to treat
the #N/A like a 0
Does that make sense?
|