Referencing an array formula

S

Sh

I have an array formula that I have set up. If certain criteria are not
found, I am getting an #N/A error (which is ok). Now I want to set up
another formula that if there is something populated (which happens to be a
number) in that cell that contains the array, I want that to populate
otherwise I want it to reference a different cell. I tried using >1, but on
the cells that contain #N/A, it will not reference the other cell. Any
suggestions?
 
S

smartin

Sh said:
I have an array formula that I have set up. If certain criteria are not
found, I am getting an #N/A error (which is ok). Now I want to set up
another formula that if there is something populated (which happens to be a
number) in that cell that contains the array, I want that to populate
otherwise I want it to reference a different cell. I tried using >1, but on
the cells that contain #N/A, it will not reference the other cell. Any
suggestions?
Click to expand...

=IF(ISNA(target),something else,target)
 

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

Cumulative formula for word table 0
Finding Text within an Array 4
Newbie Help - IF Yes No Function 0
Excel - Wich Function should I use? 1
randomly picking up an array element from an array of elements 2
Help with an Excel formula please? 7
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Referencing a named array 1

Top