We can also look at a different set of reference cells.

With 3 capture lines: C10 has data, C8 has data and C6 has data
With 2 capture lines: C10 no data, C8 has data and C6 has data
With 1 capture line: C10 no data, C8 no data, C6 has data

We're changing the reference cells because A30 was full if I had more than
one datum somewhere else (yay, mission creep).

To re-iterate the result cells desired: With 3 cap lines, pull info from
C30, with 2 cap lines pull info from C28, with one cap line pull info from
C26.


Thanks in advance!

Nick

"JMB" wrote:

Maybe you could try:
=CHOOSE(ISBLANK(Sheet3!A28)+ISBLANK(Sheet3!A30)*2+ 1,Sheet3!C30,Sheet3!C25,Sheet3!C28,"")

Since you didn't say, I used "" if both A28 and A30 are empty. And I assume
when you said "if the cell does not have text or numbers, it is empty" you
meant it is truly empty and not the null string "".




"Nick" wrote:

Hi,
I'm trying to construct a formula that does the following
=IF(AND(OR(ISTEXT(Sheet3!$A$28),ISNUMBER(Sheet3!$A $28))),OR(ISTEXT(Sheet3!A$30),ISNUMBER(Sheet3!A$30 ),Sheet3!C30,Sheet3!C28),Sheet3!C25)

In plain talk, if there is text or numbers in A28, check if there is text or
numbers in A30, if no in the first IF use c25, if no in the second arguement
use c28, if yes for both use c30

Any ideas?