The use of N/A in formulas

  • Thread starter Thread starter riddlen
  • Start date Start date
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
 
=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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set add function ignore #N/A 1
formula error 1
Formula returns #N/A 1
#N/A 5
SUMIF Formula not working 1
#REF or #N/A with "IF" formula 5
#N/A error 4
Please help on formula that will not work (If-And formula) 3

Back
Top