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%