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

#### Dmichaud61

##### Board Regular
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!

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
You can just add another IF:

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

Last edited:
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")

Much appreciated RoryA! Your solution worked perfectly.

Replies
3
Views
89
Replies
1
Views
414
Replies
8
Views
481
Replies
17
Views
463
Replies
7
Views
151

1,203,522
Messages
6,055,893
Members
444,832
Latest member
Kauri

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back