IF formula

[SAVIOBLUEFOX]

Hi there,

Greetings from a sunny Dubai.

Need some help as usual

Column C has all flight nos e.g EK562, EK523, etc. Only where flight nos are not available, the data appears as NSR.
Column N has all hotels e.g Hilton Dubai, Atlantis, etc. A few of these hotels have 'NSR' added to them e.h Hilton NSR.
My current formula in O is like =IF(ISERROR(FIND("NSR",N2)),"false","true") which workds fine and returns a value of TRUE whenever a hotel is found with NSR.

What I need?I need to change the formula in O to show value as FALSE if value in C is = NSR, irrespective of NSR being present or not in N.

Current:C N O
NSR Hilton NSR True

Needed:C N O
NSR Hilton NSR False

Hope I have explained myself well above.

Thanks in advance,
SBF

[Pepe Le Mokko]

Perhaps =IF(OR(C2="NSR",ISERROR(FIND("NSR",N2))),"false","true")

[SAVIOBLUEFOX]

Take a bow Sir...
Brilliant!!!!!
Thanks!!!!!!!!!!!!

[Pepe Le Mokko]

You're welcome