calculating water bill base on the following rules
 

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.

calculating water bill base on the following rules
 

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.

"vivian" wrote in message
...
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.