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.
Kindly in advance Monika