Water Data Worksheet
Calculate the Water Bill (Column H) as follows: Use a combination of the IF, OR, and VLOOKUP functions to calculate the water bill. Below are the parameters for calculating the water bill:
If either a customer’s bill is waived (Column C) or if the customer has used 25,000 or fewer gallons (Column G), the water bill is 0.
For all other customers, the billing rate varies based on the type of customer as shown in the BillRate table in columns M and N. The customer type for each customer is in column B of the main table. (Hint: the water bill is calculated based on a “per 1000 gallon” basis)
Solved by F. H. in 11 mins