Bob,

Thanks for replying.

That formula returned zero, even though information was in C28 in sheet3!.

I altered the formula to include the link to the other sheet

=IF(AND(Sheet3!A28<"",Sheet3!A30<""),Sheet3!C30, IF(Sheet3!A28<"",Sheet3!C25,Sheet3!C28))

Maybe I should rephrase what I'm looking for. I am copying information from
a website into sheet 3, Paste Special - Text. 90% of the time it fits one
format (2 capture lines), but the 10% of the time is split between 1 capture
line and 3 capture lines.

I chose to look at Sheet3!A30 because it is blank (nothing in the cell) for
the 90% of the time, but it is filled with 3 capture lines. Both A30 and A28
are blank when there is only 1 capture line.

So I need this formula to check A30, if that's blank check A28, if that's
blank pull information from C25. If A30 isn't blank, pull information from
C30, If A30 is blank but A28 is not blank, pull information from C28.

Thanks in advance!
"Bob Phillips" wrote:

So test for blank

=IF(AND(A28<"",A30<""),C30,IF(A28<"",C25,C28))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Nick" wrote in message
...
Bob,
Thanks for replying, if it's not text and not numbers, the cell is blank

"Bob Phillips" wrote:

What is your definition of not text and not numbers?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Nick" wrote in message
...
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?