Dont display anything above 100%

[BurghRocks]

Hi All,

I'm attempting to track progress by percentages in different columns. So
for person #1 their goal the first week is to complete 50%, the second week
75%, etc. If I have the percent to total in column A and then the subsequent
weeks percent completed in columns B, C, etc I am simply taking completed
value in column A and then dividing by the appropriate percentage.

A1 = 50% B1= A1/50% C1=A1/75%

This works until someone has completed everything earlier than expected. If
by week 1 they have completed 100% and that is the value in A1 then B1 puts
in a value of 200%. I want the cell to display only 100% if the calculated
value is over 100%.

Thanks in advance for any assistance.

Bill

 

[Peo Sjoblom]

=MIN(100%,your_formula)



--


Regards,


Peo Sjoblom

 

[Sean Timmons]

=min(100%,A1/50%)

 

[BurghRocks]

Looks like what I needed, thanks very much Sean.

=min(100%,A1/50%)