Bill costs workout for running year on daily basis

Bill costs workout for running year on daily basis

In column D is the actual meter reading

In column E is the number of days

In column F is the average per day used

In column G is the actual per day used

In column H is the per day standing charge

In column I is the actual water cost per cubic meter

In column J is the actual cost per day including standing charge plus water units cost and water units consumed

In column K is the actual running cost to date (added when put in the actual units used)

In column L is the running forecasted cost to date 1416 / 365

What I would like to perform is when I put in the measured units the functions in columns J, K, are filled automatically without any of the bottom part of the date we filled in the measured units, it could be “0” value.

So I can have a visual to date cost and running total cost, it seems average consumption is two cubic meter per day

I think you might get what you want by adding the following formula to the end of the formulae in the columns you want to be zero. Starting at row 14: *($D14<>0)

This it a bit quicker than wrapping an IF statement around the formula.


Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.
When you reply please make it clear WHO you are responding to by mentioning their name.
If we have been of assistance, please let us know. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Water Bill.xlsWater costs.doc

Hi, David A Coop

I had attached a file to this thread, I thought, and i can see two files attached.
Never mind I have attached again as per you instruction which I hope will get the attachments. I do only basic calculation this process requires more than I can deliver, I thank you for having a look at this thread.

Water Bill.xlsWater costs.doc

Again thank you.

wykoems