Show "Yes" or "No" vs. "True" or "False"

[Dmichaud61]

Greetings,

How do I modify the below formula to show Yes or No vs. True or False? The formula currently works, but shows True or False vs. Yes or No.

=IF(G2="Test",L2>=PERCENTILE($L$913:$L$1911,0.75))

Thanks!

 

[RoryA]

You can just add another IF:

=IF(G2="Test",IF(L2>=PERCENTILE($L$913:$L$1911,0.75),"Yes","No"),"No")

 

[gaz_chops]

Your formula returns L2>=PERCENTILE($L$913:$L$1911,0.75) if true, do you want to change that to Yes?

If you just want to add "No", then

=IF(G2="Test",L2>=PERCENTILE($L$913:$L$1911,0.75),"No")

 

[Dmichaud61]

Much appreciated RoryA! Your solution worked perfectly.