I am using this formula to extract the standard deviation.

=STDEV.S(IF([player_id]=D3,IF([Week]<=A3,IF([Year]=B3,[G-1]))))
However, I would like to cap the incoming value of [G-1] at 0.5. A few come in over 0.5, as high as 1.
I do not want to throw away these numbers, just reduce them to 0.5.

Is this possible?

Thanks