Spreadsheet: 157896d1337910449-programming-conditional-formulas-1767budget
Sheet: Sheet1

 | DA | TOTAL $ | TOTAL BUDGET | OPERATING | FOOD COST | MANAGEMENT | PAYROLL BUDGET
WEEK 1 | 892
WEEK 2 | 832
WEEK 3 | 835 |  |  |  |  |  |  |  | Here's the formula
WEEK 4 | 835
TOTAL | 848.5
OVERALL CHART |  |  |  | use only one column i used left don't include the second one. |  |  | look at also colored red same percentage if same like this
0 | 802 | 0.774 |  | 0 | 0.774 |  | AND You don't have 804
803 | 834 | 0.774 |  | 803 | 0.774 |  |  | 0 | 0.774 | 0 to 844 will be .774
835 | 865 | 0.769 |  | 835 | 0.769 |  |  | 835 | 0.769
866 | 897 | 0.765 |  | 866 | 0.765 |  | Another set | 866 | 0.765
898 | 929 | 0.764 |  | 898 | 0.764 |  |  | 898 | 0.764
930 | 960 | 0.757 |  | 930 | 0.757 |  | [NAME] | 930 | 0.757
961 | 992 | 0.742 |  | 961 | 0.742 |  |  | 961 | 0.742
993 | 1023 | 0.732 |  | 993 | 0.732 |  |  | 993 | 0.732
1024 | 1055 | 0.723 |  | 1024 | 0.723 |  |  | 1024 | 0.723
1056 | 1086 | 0.708 |  | 1056 | 0.708 |  | >>>>>> use this >> | 1056 | 0.708
1087 | 1118 | 0.702 |  | 1087 | 0.702 |  |  | 1087 | 0.702
1119 | 1150 | 0.695 |  | 1119 | 0.695 |  | another one for error checking | 1119 | 0.695
1151 | 1181 | 0.684 |  | 1151 | 0.684 |  |  | 1151 | 0.684
1182 | 1213 | 0.679 |  | 1182 | 0.679 |  |  | 1182 | 0.679
1214 | 1244 | 0.67 |  | 1214 | 0.67 |  |  | 1214 | 0.67
1245 | 1276 | 0.664 |  | 1245 | 0.664 |  |  | 1245 | 0.664
1277 | 1308 | 0.66 |  | 1277 | 0.66 |  |  | 1277 | 0.66
1309 | 1339 | 0.654 |  | 1309 | 0.654 |  |  | 1309 | 0.654
1340 | 1371 | 0.649 |  | 1340 | 0.649 |  |  | 1340 | 0.649
1372 | 1402 | 0.644 |  | 1372 | 0.644 |  |  | 1372 | 0.644
1403 | 1434 | 0.639 |  | 1403 | 0.639 |  |  | 1403 | 0.639
1435 | 1465 | 0.636 |  | 1435 | 0.636 |  |  | 1435 | 0.636
1466 | 1497 | 0.636 |  | 1466 | 0.636 |  |  | 1466 | 0.636
1498 | 1529 | 0.633 |  | 1498 | 0.633 |  |  | 1498 | 0.633
1530 | 1560 | 0.628 |  | 1530 | 0.628 |  |  | 1530 | 0.628
1561 | 1592 | 0.625 |  | 1561 | 0.625 |  |  | 1561 | 0.625
1593 | 1623 | 0.625 |  | 1593 | 0.625 |  |  | 1593 | 0.625
1624 | 1655 | 0.625 |  | 1624 | 0.625 |  |  | 1624 | 0.625
1656 | 1687 | 0.625 |  | 1656 | 0.625 |  |  | 1656 | 0.625
1688 | 1718 | 0.624 |  | 1688 | 0.624 |  |  | 1688 | 0.624
1719 | 1750 | 0.621 |  | 1719 | 0.621 |  |  | 1719 | 0.621
1751 | 1781 | 0.618 |  | 1751 | 0.618 |  |  | 1751 | 0.618
1782 | 1813 | 0.618 |  | 1782 | 0.618 |  |  | 1782 | 0.618
1814 | 1844 | 0.616 |  | 1814 | 0.616 |  |  | 1814 | 0.616
1845 | 1876 | 0.613 |  | 1845 | 0.613 |  |  | 1845 | 0.613
1877 | 1908 | 0.609 |  | 1877 | 0.609 |  |  | 1877 | 0.609
1909 | 1939 | 0.606 |  | 1909 | 0.606 |  |  | 1909 | 0.606
1940 | 1971 | 0.605 |  | 1940 | 0.605 |  |  | 1940 | 0.605
1972 | 2002 | 0.604 |  | 1972 | 0.604 |  |  | 1972 | 0.604
2003 | 2034 | 0.601 |  | 2003 | 0.601 |  |  | 2003 | 0.601
2035 | 266 | 0.598 |  | 2035 | 0.598 |  |  | 2035 | 0.598
2067 | 2097 | 0.596 |  | 2067 | 0.596 |  |  | 2067 | 0.596
2098 | 2129 | 0.591 |  | 2098 | 0.591 |  |  | 2098 | 0.591
2130 | 2160 | 0.589 |  | 2130 | 0.589 |  |  | 2130 | 0.589
2161 | 2192 | 0.587 |  | 2161 | 0.587 |  |  | 2161 | 0.587
2193 | 2223 | 0.585 |  | 2193 | 0.585 |  |  | 2193 | 0.585
2224 | 99999 | 0.583 |  | 2224 | 0.583 |  |  | 2224 | 0.583