The use of N/A in formulas

R

riddlen

How can I use N/A in a formula as not to get an error message, but an actual
number back ?

For example when adding up cells and then dividing by a number and one of
the cell values is N/A, because it is not applicable.

Thank you
 
G

Gary''s Student

=AVERAGE(IF(NOT(ISNA(A1:A50)),A1:A50))

This is an array formula that must be entered with CNTRL-SHFT-ENTER and not
just the ENTER key.
 
Top