formula

[highlander_jlp]

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%

 

[JLatham]

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]

JLatham thank you this works for me thank you again

 

[JLatham]

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