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

=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.
--
Gary''s Student - gsnu200837


"riddlen" wrote:

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