calculating water bill base on the following rules

V

vivian

if customer bill is waived place 0 in the water bill columm, gal used must be
greater than 25,000 otherwise, the water bill is 0. For all other accounts,
the billing rate varies based on the type of customer. billing rate is $3,2
&1.50 per thousand gallons used depending on the type of customer, there is a
billing rate worksheet. I'm using formula =if(c2="Yes" or g2<25,000,0,
vlookup(b2,page!b3:c5,2)*g2) is not working. Need help please.
Thank you.
 
F

Fred Smith

Yes, you need help. With respect to the formula you posted, Excel doesn't
use "or" that way, and you can't include a comma in a number (Excel uses
that to determine the end of the test). So try it this way:
=if(or(c2="Yes",g2<25000),0,vlookup(b2,page!b3:c5,2)*g2)

If you need more help, post back with details.

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top