CODEWITHSUNDEEP
excelif-statementnested
Nadz
Nadz

Reputation: 103

nested (IF-AND-IF-ISERROR) statement (Excel)

I am trying to overcomplicate a formula, where I basically check if cell 1 = 70 and cell 2 <> 70, then search another cell for a specific text ("OF" in my case). If the text exists, return "YES", otherwise keep everything as it is.

This is what I have so far

=IF(YD2=70 AND(YE2<>70, IF(OR(ISNUMBER(SEARCH("*OF*",YA2))), "YES", YD2)YD2))

Help? :)

Upvotes: 0

Views: 1292

Answers (1)

Simon1979
Simon1979

Reputation: 2108

I think this will do it:

=IF(AND(YD2=70,YE2<>70),IF(OR(ISNUMBER(SEARCH("*OF*",YA2))),"YES",YD2),YD2)

You were just missing the , before the last YD2 and the AND I reworked.

Upvotes: 1

Related Questions