Solved What is wrong with my nested IF functions in Excel?

May 11, 2016 at 08:48:49
Specs: Windows XP
I don't know what I'm doing wrong with my nested IF/AND functions.
Column P shows whether the project met on time delivery with a Y or N.
Column Q shows whether the lab had the project in billable on time with a Y or N.
I would like column R to show who was responsible for the delay.

If P1 is "N" and Q1 is "Y", R1 should say "RG"
If P1 is "N" and Q1 is "N", R1 should say "Lab"
If P1 is "Y" and Q1 is "N", R1 should say "See Note"
Otherwise, R1 should be blank.

Will someone help me figure out the error in my function? R1 says #NAME?.

=IF(AND(P1=”N”,Q1=”Y”),"RG",IF(AND(P1=”N”,Q1=”N”),"Lab",IF(AND(P1=”Y”,Q1=”N”),"See Note","")))

Thank you!!

message edited by CandiTheChemNerd


See More: What is wrong with my nested IF functions in Excel?

Report •


#1
May 11, 2016 at 08:59:26
✔ Best Answer
You didn't say what error your were getting, so it's a little hard to tell you what's wrong.

I can tell you that your formula worked just fine for me after I replaced the smart quotation marks () with straight quotation marks ("). Before I did that I was getting a #NAME error. Excel doesn't like smart quotes in formulas.

If that is not the error you were getting, please provide some more detail.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

#2
May 11, 2016 at 09:04:06
Oh my goodness. Thank you, I was writing the formula in Word and copying it in. I replaced the quotation marks and it is just fine. Haha!

Report •

Related Solutions


Ask Question