Hello Excel Guru's

I am an amateur, trying to learn from exhaustive knowledge pool available in many of posts available here.

Hi,

I am trying to with below formula to get the desired values but unable to get through, please help:

=IF(O6<>"False",IF(P6<>"False", "Existing",IF(Q6="True","New")))

where:

O6 = True
P6=False
Q6=True

Still I get output as "Existing" where in it should display "New".

Suggestion please.

Thanks in advance

Hi All,

I found the solution, I just removed quote (") for False and True, it worked.

Thanks