formula
 

a b c
d
1 Mon 0 0.00% 100% 100%
2 Tue -5141 -7.32% 93% 100%
3 Wed -5181 -7.84% 92% 100%
4 Thu 0 0.00% 100% 100%
5 fri 0 0.00% 100% 100%

6 Totals -10322 -3.15% 97% 100%

Sorry if i get this wrong how do i wright this as formula if more than 2
cells in B have a -% then c6 =d6-b6 if not more than two cells then c6
should read 100%

formula
 

In C6:
=IF(COUNTIF(C1:C5,"<0")2,D6-B6,1)
if C6 is formatted as %, then it will display 100% when there less than 3
negative values in B1:B5.

"highlander_jlp" wrote:

a b c
d
1 Mon 0 0.00% 100% 100%
2 Tue -5141 -7.32% 93% 100%
3 Wed -5181 -7.84% 92% 100%
4 Thu 0 0.00% 100% 100%
5 fri 0 0.00% 100% 100%

6 Totals -10322 -3.15% 97% 100%

Sorry if i get this wrong how do i wright this as formula if more than 2
cells in B have a -% then c6 =d6-b6 if not more than two cells then c6
should read 100%

formula
 

JLatham thank you this works for me thank you again

"JLatham" wrote:

In C6:
=IF(COUNTIF(C1:C5,"<0")2,D6-B6,1)
if C6 is formatted as %, then it will display 100% when there less than 3
negative values in B1:B5.

"highlander_jlp" wrote:

a b c
d
1 Mon 0 0.00% 100% 100%
2 Tue -5141 -7.32% 93% 100%
3 Wed -5181 -7.84% 92% 100%
4 Thu 0 0.00% 100% 100%
5 fri 0 0.00% 100% 100%

6 Totals -10322 -3.15% 97% 100%

Sorry if i get this wrong how do i wright this as formula if more than 2
cells in B have a -% then c6 =d6-b6 if not more than two cells then c6
should read 100%

formula
 

Glad to hear it, and thanks for the thanks! Much appreciated.

"highlander_jlp" wrote:

JLatham thank you this works for me thank you again

"JLatham" wrote:

In C6:
=IF(COUNTIF(C1:C5,"<0")2,D6-B6,1)
if C6 is formatted as %, then it will display 100% when there less than 3
negative values in B1:B5.

"highlander_jlp" wrote:

a b c
d
1 Mon 0 0.00% 100% 100%
2 Tue -5141 -7.32% 93% 100%
3 Wed -5181 -7.84% 92% 100%
4 Thu 0 0.00% 100% 100%
5 fri 0 0.00% 100% 100%

6 Totals -10322 -3.15% 97% 100%

Sorry if i get this wrong how do i wright this as formula if more than 2
cells in B have a -% then c6 =d6-b6 if not more than two cells then c6
should read 100%