Nesting IF Functions

jcvanhorn

New Member
Joined
Jul 14, 2011
Messages
2
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

I can get everything to work appropriately except the last one, which is currently returning FALSE. If I could change that to a blank cell, it would be awesome.

Thank you for the help!
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,400
The red part is if J77 is not blank and not Yes

Code:
=IF(J77="","",IF(J77="Yes",IF(J74<>"",IF(J75<>"","AM/PM",J74),IF(J75<>"",J75,"No Indication")),[COLOR="Red"]"J77 not blank and not 'Yes'"[/COLOR]))
 

jcvanhorn

New Member
Joined
Jul 14, 2011
Messages
2
That works. Thank you!

I was using IF AND but this works great. I like how it allows for the ability to catch if there is something else in the J77 cell.

Thank you.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,594
Messages
5,625,695
Members
416,127
Latest member
MALEPINZON

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top