Spreadsheet: 847719d1698588513-how-can-i-change-the-forumla-to-subtract-from-a-given-amount-electrical-budget-checking-formula-example_oct-29-23
Sheet: Sheet1

 | The Cost of Electric ! |  |  |  |  |  |  |  | Monthly Total Budget # |  |  |  |  | SELECT MONTH | SELECT YEAR | SELECT BLDG |  | 1983 |  |  |  | AVERAGE COMBINED  COST FOR ELECTRIC
 |  |  |  |  |  |  |  |  | 254.17 |  |  |  |  | JAN | 1983-12-01 00:00:00 | HOUSE |  |  |  | CURRENT MONTH FOR THE GARAGE
 | HOUSE | Current Year |  | MAIN BLDG - AVG KWH PER MONTH ---> |  |  | Select Year
 |  | Current Month |  | MIAN BLDG - AVG COST PER MONTH --->
 | Previous Year Compare |  |  |  |  |  | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB |  | GARAGE / BLDG-2
 |  |  |  |  |  |  | YEARS GRAND TOTAL
 | GARAGE | Current Year |  | OTHER BLDG's - AVG KWH PER MONTH
 |  | Current Month |  | OTHER BLDG's - AVG COST  PER MONTH
 | Previous Year Compare
 |  |  |  |  |  |  |  |  |  | MONTHS | YEARS
 |  |  |  |  |  |  |  | MONTHLY BUDGET NUMBERS |  | January | 2022-01-01 00:00:00
 | BILLING MONTH | BILLING YEAR | MAIN BLDG | KWH USED MAIN BLDG | OTHER BLDG's | KWH USED OTHER BLDG's | COMBINED TOTAL | MAIN BLDG | OTHER BLDGS | February | 2023-01-01 00:00:00 |  |  | NOV
 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | 284.85 |  | 37.63 |  |  |  |  | March | 2024-01-01 00:00:00 |  |  | DEC
 | 2022-02-01 00:00:00 | 2022-02-01 00:00:00 | 198.93 |  | 38.5 |  |  |  |  | April | 2025-01-01 00:00:00
 | 2022-03-01 00:00:00 | 2022-03-01 00:00:00 | 278.28 |  | 40.04 |  |  |  |  | May | 2026-01-01 00:00:00
 | 2022-04-01 00:00:00 | 2022-04-01 00:00:00 | 252.14 |  | 39.78 |  |  |  |  | June | 2027-01-01 00:00:00
 | 2022-05-01 00:00:00 | 2022-05-01 00:00:00 | 201.41 |  | 41.92 |  |  |  |  | July | 2028-01-01 00:00:00
 | 2022-06-01 00:00:00 | 2022-06-01 00:00:00 | 181.89 |  | 45.46 |  |  |  |  | August | 2029-01-01 00:00:00
 | 2022-07-01 00:00:00 | 2022-07-01 00:00:00 | 171.12 |  | 46.66 |  |  |  |  | September | 2030-01-01 00:00:00
 | 2022-08-01 00:00:00 | 2022-08-01 00:00:00 | 159.74 |  | 47.8 |  |  |  |  | October | 2031-01-01 00:00:00
 | 2022-09-01 00:00:00 | 2022-09-01 00:00:00 | 183.23 |  | 50.92 |  |  |  |  | November | 2032-01-01 00:00:00
 | 2022-10-01 00:00:00 | 2022-10-01 00:00:00 | 185.71 |  | 43.01 |  |  |  |  | December | 2033-01-01 00:00:00
 | 2022-11-01 00:00:00 | 2022-11-01 00:00:00 | 198.69 |  | 41.81 |  |  |  |  |  | 2034-01-01 00:00:00
 | 2022-12-01 00:00:00 | 2022-12-01 00:00:00 | 138.06 | 831 | 44.95 | 115 |  |  |  | Problem | 2035-01-01 00:00:00
 | 2023-01-01 00:00:00 | 2023-01-01 00:00:00 | 138.06 | 831 | 100 | 115 |  | 204.17 | 50 |  | 2036-01-01 00:00:00
 | 2023-02-01 00:00:00 | 2023-02-01 00:00:00 | 182.73 | 1113 | 45.83 | 125 |  | 204.17 | 50 | False | 2037-01-01 00:00:00
 | 2023-03-01 00:00:00 | 2023-03-01 00:00:00 | 133.83 | 792 | 44.11 | 107 |  | 204.17 | 50 | False | 2038-01-01 00:00:00
 | 2023-04-01 00:00:00 | 2023-04-01 00:00:00 | 124.32 | 737 | 43.29 | 101 |  | 204.17 | 50 | False | 2039-01-01 00:00:00
 | 2023-05-01 00:00:00 | 2023-05-01 00:00:00 | 246.23 | 1526 | 43.59 | 104 |  | 204.17 | 50 | False | 2040-01-01 00:00:00
 | 2023-06-01 00:00:00 | 2023-06-01 00:00:00 | 210.71 | 1296 | 42.83 | 96 |  | 204.17 | 50 | False | 2041-01-01 00:00:00
 | 2023-07-01 00:00:00 | 2023-07-01 00:00:00 | 220.79 | 1167 | 44.52 | 106 |  | 204.17 | 50 | False | 2042-01-01 00:00:00
 | 2023-08-01 00:00:00 | 2023-08-01 00:00:00 | 246.3 | 1300 | 47.62 | 134 |  | 204.17 | 50 | False | 2043-01-01 00:00:00
 | 2023-09-01 00:00:00 | 2023-09-01 00:00:00 | 128.96 | 653 | 49.76 | 156 |  | 204.17 | 50 | False | 2044-01-01 00:00:00
 | 2023-10-01 00:00:00 | 2023-10-01 00:00:00 | 134.92 | 771 | 51.85 | 176 |  | 204.17 | 50 | False | 2045-01-01 00:00:00
 | 2023-11-01 00:00:00 | 2023-11-01 00:00:00 |  |  |  |  |  | 204.17 | 50 | False | 2046-01-01 00:00:00
 | 2023-12-01 00:00:00 | 2023-12-01 00:00:00 |  |  |  |  |  | 204.17 | 50 | False | 2047-01-01 00:00:00
 | 2024-01-01 00:00:00 | 2024-01-01 00:00:00 |  |  |  |  |  |  |  | False | 2048-01-01 00:00:00
 | 2024-02-01 00:00:00 | 2024-02-01 00:00:00 |  |  |  |  |  |  |  | False | 2049-01-01 00:00:00
 | 2024-03-01 00:00:00 | 2024-03-01 00:00:00 |  |  |  |  |  |  |  | False | 2050-01-01 00:00:00
 | 2024-04-01 00:00:00 | 2024-04-01 00:00:00 |  |  |  |  |  |  |  | False
 | 2024-05-01 00:00:00 | 2024-05-01 00:00:00 |  |  |  |  |  |  |  | False
 | 2024-06-01 00:00:00 | 2024-06-01 00:00:00 |  |  |  |  |  |  |  | False
 | 2024-07-01 00:00:00 | 2024-07-01 00:00:00 |  |  |  |  |  |  |  | False
 | 2024-08-01 00:00:00 | 2024-08-01 00:00:00 |  |  |  |  |  |  |  | False
 | 2024-09-01 00:00:00 | 2024-09-01 00:00:00 |  |  |  |  |  |  |  | False
 | 2024-10-01 00:00:00 | 2024-10-01 00:00:00 |  |  |  |  |  |  |  | False
 | 2024-11-01 00:00:00 | 2024-11-01 00:00:00 |  |  |  |  |  |  |  | False
 | 2024-12-01 00:00:00 | 2024-12-01 00:00:00 |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  | False