Capping at 100%

[horhif]

Hi,


Basically I want the formula to cap at 100%

=COUNTIF(L7:Q7,"Y")*100

If any cell between L7 to Q7 has a ‘Y’ value I want it to return the value as 100%.


Some colleagues should only put in one yes, but at the moment if they put in two ‘Y’ details then it is coming back with the formula of 200%.

I need it to cap at 100%.




Thanks for your help

 

[VoG]

Perhaps

=MIN(100,COUNTIF(L7:Q7,"Y")*100)