Help Pls

[Max]

I have a worksheet with 3 cells that have formula in them.
Based on criteria in another work sheet those cells
(AL5:AL7) will return either text (James, Henry, Robert,
Will) or will return "". I have another cell that I want
to identify the first instance of text and return that
value. I've tried IF formulas but don't seme to be getting
anywhere.
=IF(AL5="",AL6,IF(AL6="",AL7,AL5))
This returns the value if the result in AL5="" but does
not return the value in AL7 if both AL5 and AL6 ="".

I also tried
=IF(AL5=""),IF(AL6=""),AL7,AL5))
This will return the result in AL7 if both AL5 and AL6 =""
but does not return the value in AL5 if AL5 does not ="".

Any Help would be appreciated.

 

[Andy B]

Max

Try this:

=IF(AL5="",IF(AL6="",AL7,AL6),AL5)

Andy.

 

[Paul]

I have a worksheet with 3 cells that have formula in them.
Based on criteria in another work sheet those cells
(AL5:AL7) will return either text (James, Henry, Robert,
Will) or will return "". I have another cell that I want
to identify the first instance of text and return that
value. I've tried IF formulas but don't seme to be getting
anywhere.
=IF(AL5="",AL6,IF(AL6="",AL7,AL5))
This returns the value if the result in AL5="" but does
not return the value in AL7 if both AL5 and AL6 ="".

I also tried
=IF(AL5=""),IF(AL6=""),AL7,AL5))
This will return the result in AL7 if both AL5 and AL6 =""
but does not return the value in AL5 if AL5 does not ="".

Any Help would be appreciated.

If I have followed what you want correctly, this is the formula:
=IF(AL5="",IF(AL6="",AL7,AL6),AL5)