# Formula

• Dear Experts

Please can you help me with my problem. I want to create a formula for the following utility bill / cost. the only unit that changes is the "units used".

month jan = 100 units
month feb = 110 units
therefor units used in Jan = 10 units

units used 10 x 25 (pounds - cost) = 250 pounds
250 pounds + 8% (tax) = 270 pounds

270 pounds + 19% (high time tax) = 321.30 (pounds)

total cost of the 10 units used =

IN SUMMARY I SIMPLY WANT TO ADD INTO SPREAD SHEET THE UNITS USED AND LIKE MAGIC THE ANSWER WILL APEAR. This is request for help in creating a formula.

Dec Feb

A B C
3 Water 131 140
4 Water Dif 9
5 Water*25 225
6 x 8% 18
7 Sub Tl 243
8 x 19% 46.17
9 W Total 289.17

My formula is:

=SUM((((C4*25)*0.08)+(C4*25))*0.19)+((((C4*25)*0.08))+(C4*25))

The formula does not include water difference calculation ie 3c-3b becuase i dont know how.

• Re: Formula

Monika, welcome to ozgrid.

You really should take care where you post questions. This was originally posted in That's Cool, clearly marked no questions.

Not only does this make the site "untidy", it lessens your chances of help.

I have moved it to Excel/VBA

• Re: Formula

What are you going to do with the results?
Keep it as a perm record? Print it? Just look it up on demand?
this could make a difference as to the approach...

If all you want to do is look at it on demand, one record at a time...
If you need to print it for each customer, each month...
If you intend to create a perm record...but if you already have the perm record there would be no need to store the same information twice when you can always mine the data for your results.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!