Nested IF with various values_if

[loribear180]

Hello,
I'm new to Excel and I've been going around in circles trying to figure out if I can even do what I need to via nested IF functions. Here is a screenshot of my what I have so far:

1. The first IF function I need to populate in Q28 is IF(D28="N", "N/A", ""). I want Q28 to remain blank if nothing is entered (to make sure the spreadsheet looks clean).
2. I also need Q28 to be dependent on O28. IF(O28="NQ","N").

I'm at a loss, because I managed to create this IF(D28="N","N/A", IF(O28="NQ","N")). However, if D28 is blank, cell Q28 reads FALSE. I could also be totally wrong and not even using the correct function, sorry, bear with me. To complicate matters, I am not allowed to change the format of this horribly designed spreadsheet (if you saw the entire thing you would understand). I'm learning what I can to try and automate some of these fields. HELP!?

 

[Fluff]

Hi & welcome to MrExcel.
You need to add the false part for the 2nd IF like

IF(D28="N","N/A", IF(O28="NQ","N",""))

 

[loribear180]

Hi & welcome to MrExcel.
You need to add the false part for the 2nd IF like

IF(D28="N","N/A", IF(O28="NQ","N",""))

OMG I spent almost two hours trying to figure out what was wrong with my function. Thank you so much!!!

I assumed if I entered that part in the second IF function, then it would only leave Q28 blank if O28 was blank.

 

[Fluff]

You're welcome & thanks for the feedback.