J3 contains the results from a cell calculating the DATEDIF function elsewhere on the sheet from the last bill date to today (using the TODAY() function)ġ.05 is the VAT on the whole thing (unless Rishi has a change of heart soon).Īny comments or suggestions would be very welcome. I4 contains a cell returning the difference between the last reading and today's My attempt so far (which does work) is =SUM(((i4*29.64)+(j3*32.15))/100)*1.05 Go To Payment Options Outages Report or Check Outages Start/Stop Service Manage or Transfer Service Smart Options - Made Simple From automatic payments to averaged monthly bills - streamline your services with digital billing options. I'd be interested to see any formulae that forum members have developed (Excel or other). I would like to incorporate this into my main formula but I can't see a way of doing this. Now the technical part: I have calculated the days elapsed since the last bill using the DATEDIF function and this reads the two dates from two cells on the sheet. I can now enter my current reading and see exactly what my next bill will be, including VAT. ![]() Choose your own due date for bills, its free, easy, and wont affect your preferred payment method. If your monthly bill is higher than expected, look at the common causes affecting it. Get a Predictable Bill High Bill Factors. ![]() I have written an Excel formula to keep track of my usage since the previous bill - I expect that some people on this forum have done the same or similar. Have your bill be about the same amount all year, at no additional charge.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |