Nested IF formula

[zicitron]

Hi all,

I'm using Excel 2013 and I need a nested formula in a column of my worksheet but I just can't get around the right syntax.
I need the formula to do the following:

IF G4 = "TOR" and Q4 = "TO", THEN "Correct", else "Wrong"
IF G4 = "DMCR" and Q4 = "DMC", THEN "Correct", else "Wrong"
IF G4 = "OTAR" AND Q4 = "OTA", THEN 'Correct', else "Wrong"

Thanks for helping!

 

[cyrilbrd]

Hi all,

I'm using Excel 2013 and I need a nested formula in a column of my worksheet but I just can't get around the right syntax.
I need the formula to do the following:

IF G4 = "TOR" and Q4 = "TO", THEN "Correct", else "Wrong"
IF G4 = "DMCR" and Q4 = "DMC", THEN "Correct", else "Wrong"
IF G4 = "OTAR" AND Q4 = "OTA", THEN 'Correct', else "Wrong"

Thanks for helping!

Hi, would you consider this: =IF(LEFT(G4,LEN(G4)-1)=Q4,"CORRECT","Wrong") copied anywhere in your file.
Would that work for you?

 

[zicitron]

Thanks for your input, cyrilbrd. I do understand the logic behind your proposed formula but unfortunately it won't work as I have another option that I did not list: IF G4 = "DR" and Q4 = "DIR", then "Correct", else "Wrong". Didn't bother to list this one as I thought I would amend the proposed solution accordingly!

 

[cyrilbrd]

Thanks for your input, cyrilbrd. I do understand the logic behind your proposed formula but unfortunately it won't work as I have another option that I did not list: IF G4 = "DR" and Q4 = "DIR", then "Correct", else "Wrong". Didn't bother to list this one as I thought I would amend the proposed solution accordingly!

=IF(AND(G4="DR",Q4="DIR"),"CORRECT",IF(LEFT(G4,LEN(G4)-1)=Q4,"CORRECT","Wrong"))

 

[cyrilbrd]

Or =IF(Q4=INDEX({"dir","dmc","ota","to"},MATCH(G4,{"DR","DMCR","OTAR","TOR"},0)),"CORRECT","Wrong"))
Advantage of this would be the defined list of possible match.
Would that work for you?