Nesting IF Functions

**jcvanhorn** · 11-02-2011, 04:38 PM

I'm trying to solve the following problem and am getting close but I'm not quite there. Any insight would be much appreciated.

What I'd like the function to do:

if j77 equals "Yes" AND there is text in j74 AND text in J75, return "AM/PM"
if j77 equals "Yes" AND there is text in j74 but none in j75, return text in j74
if j77 equals "Yes" and there is no text in j74 but j75 contains text, return text in j75
if j77 equals "Yes" but there is no text in j74 AND no text in j75, return "No Indication"
If j77 is blank, return a blank cell instead of FALSE

Thank you for the help!

**MarvinP** · 11-02-2011, 04:46 PM

Hi jcvanhorn and welcome to the forum,

I believe there is a smaller limit to the number of nested if statements allowed in Excel 2003 compared to newer versions.

See http://spreadsheetpage.com/index.php..._if_functions/ to see if it helps.

**jcvanhorn** · 11-02-2011, 04:55 PM

I'm actually using 2007. Just changed my profile. Does that change things?

**ConneXionLost** · 11-02-2011, 05:35 PM

How about:

=IF(AND(J77="Yes",ISTEXT(J74),ISTEXT(J75)),"AM/PM",IF(AND(J77="Yes",ISTEXT(J74)),J74,IF(AND(J77="Yes",ISTEXT(J75)),J75,IF(J77="Yes","No Indication",""))))

Cheers,