Hello, I am so fortunate to have found your site!
I am sooo lost on this Excel problem:
Calculate the water bill on the following rules:
1.If a customer's bill is waived,place a 0 in the water bill column.
2.Gallons Used must be greater than 25,000 gallons during the quarter,otherwise the water bill will be 0.
3.For all other accounts ,the billing rate varies based on type of customer. The billing rate is $3,$2,or $1.50 per thousand gallons used depending on the type of customer.
For example, a commercial customer using 75,000 gallons has a water bill of $225(75X$3),whereas a government customer using 100,000 gallons pays $150(100x$1.50).A commercial customer using 15,000 gallons has a water bill of 0.
The types of customers and rates are:
COM-$3
NPROFIT-$2
GOV-$1.50
The way it is set up I cannot just click a cell and a letter and # show up, I have to put the brackets and click on Customer Type, Gallons Used,Bill Waived(which has a Yes or No in the columns), and I am trying to calculate all this in the Water Bill Column. I am so lost and frustrated
any help would be appreciated! Thanks Bunches! Melissa
Ps I am using Microsoft Office 2007
I am sooo lost on this Excel problem:
Calculate the water bill on the following rules:
1.If a customer's bill is waived,place a 0 in the water bill column.
2.Gallons Used must be greater than 25,000 gallons during the quarter,otherwise the water bill will be 0.
3.For all other accounts ,the billing rate varies based on type of customer. The billing rate is $3,$2,or $1.50 per thousand gallons used depending on the type of customer.
For example, a commercial customer using 75,000 gallons has a water bill of $225(75X$3),whereas a government customer using 100,000 gallons pays $150(100x$1.50).A commercial customer using 15,000 gallons has a water bill of 0.
The types of customers and rates are:
COM-$3
NPROFIT-$2
GOV-$1.50
The way it is set up I cannot just click a cell and a letter and # show up, I have to put the brackets and click on Customer Type, Gallons Used,Bill Waived(which has a Yes or No in the columns), and I am trying to calculate all this in the Water Bill Column. I am so lost and frustrated

Ps I am using Microsoft Office 2007
Last edited: