wrote:
From the above example column C will equal 80%, 50%, 167%, 67%
I need the function for column D so the D will equal 80%, 50%, 100% 67%
I never what the value of column D to be greater than 100%

=MAX(1,C1)

formatted as Percentage.

Note that 80% is 0.80, and 167% is 1.67. So 1.00 is 100%.