Dont display anything above 100%
 

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

Dont display anything above 100%
 

=MIN(100%,your_formula)



--


Regards,


Peo Sjoblom

"BurghRocks" wrote in message
...
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

Dont display anything above 100%
 

=min(100%,A1/50%)

"BurghRocks" wrote:

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

Dont display anything above 100%
 

Looks like what I needed, thanks very much Sean.

"Sean Timmons" wrote:

=min(100%,A1/50%)

"BurghRocks" wrote:

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