IF Statement Logical Test

[brijeshkeni]

Hi All,


Can you please advise If text can be added in the logical test.

IF(D1="Group Leader", Yes, No)

But when D1 is Group Leader it displays the result as No

Please advise.

Best Regards,

Brijesh Keni

 

[NARAYANK991]

Hi Brijesh ,


I think the correct syntax should be :


=IF(D1="Group Leader","Yes","No")


Narayan

 

[kuldeepjainesl]

Hi Brijeshkeni,


In case you want to make it more falxible without hvaing to take care of "How excel work on text" you can go with.


Formula in B1 =IF(A1=$E$1,$C$1,$D$1) where....


"A"--------------------"B"----------------"C"-------------------"D"-------------------- "E"------

Data values---Answer coloum---True condition text---False condition text-----Condition to be checked.


Drag down as needed.


Regards,

Kuldeep