Someone please help me with these formulas! I am so upset I can not figure these out. PLEASE HELP 
1. Enter a formula to calculate the number of gallons billed, based on the following rules: If a customer's bill is waived (Bill Waived column) or the number of gallons used is less than 25,000 (Gal Used column), display 0 in Gal Billed column; otherwise display the value from the gallon used column in the gal billed column
2. Enter a Formula to calculate the water bill based on the following rules: The billing rate varies based on the type pf customer (cust type column). The billing rate is $3, $2, or $1.50 per thousand gallons billed, depending on the customer type(see the lookup table in cells b2:c5 of the billing rate worksheet)
**billing rate COM-$3 NPROFIT-$2 Gov-$1.50**
heres what my worksheet looks like. please help me with what each of these formulas are.
[TABLE="width: 777"]
<TBODY>[TR]
[TD]Customer Name[/TD]
[TD]Cust Type[/TD]
[TD]Bill Waived[/TD]
[TD]Taxable[/TD]
[TD]Billing Year[/TD]
[TD]Gal Used[/TD]
[TD]Gal Billed[/TD]
[TD]Water bill[/TD]
[/TR]
[TR]
[TD]Red Lake Chapter[/TD]
[TD]NPROFIT[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]108,300[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amity Church[/TD]
[TD]NPROFIT[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]55,160[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Church of Christ[/TD]
[TD]NPROFIT[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]32,430[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NM State Highway[/TD]
[TD]GOV[/TD]
[TD]No[/TD]
[TD]No[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]95,660[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Spot Free Power Wash[/TD]
[TD]COM[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]281,200[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CIT Apartment Complex[/TD]
[TD]COM[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]257,000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Housing Agency[/TD]
[TD]GOV[/TD]
[TD]No[/TD]
[TD]No[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]23,300[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Pinon Pizza Edge[/TD]
[TD]COM[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]81,110[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Department of Agriculture[/TD]
[TD]GOV[/TD]
[TD]No[/TD]
[TD]No[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]2,783,000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chevron Station[/TD]
[TD]COM[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]1,131,600[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL span=2></COLGROUP>[/TABLE]

1. Enter a formula to calculate the number of gallons billed, based on the following rules: If a customer's bill is waived (Bill Waived column) or the number of gallons used is less than 25,000 (Gal Used column), display 0 in Gal Billed column; otherwise display the value from the gallon used column in the gal billed column
2. Enter a Formula to calculate the water bill based on the following rules: The billing rate varies based on the type pf customer (cust type column). The billing rate is $3, $2, or $1.50 per thousand gallons billed, depending on the customer type(see the lookup table in cells b2:c5 of the billing rate worksheet)
**billing rate COM-$3 NPROFIT-$2 Gov-$1.50**
heres what my worksheet looks like. please help me with what each of these formulas are.
[TABLE="width: 777"]
<TBODY>[TR]
[TD]Customer Name[/TD]
[TD]Cust Type[/TD]
[TD]Bill Waived[/TD]
[TD]Taxable[/TD]
[TD]Billing Year[/TD]
[TD]Gal Used[/TD]
[TD]Gal Billed[/TD]
[TD]Water bill[/TD]
[/TR]
[TR]
[TD]Red Lake Chapter[/TD]
[TD]NPROFIT[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]108,300[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Amity Church[/TD]
[TD]NPROFIT[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]55,160[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Church of Christ[/TD]
[TD]NPROFIT[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]32,430[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]NM State Highway[/TD]
[TD]GOV[/TD]
[TD]No[/TD]
[TD]No[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]95,660[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Spot Free Power Wash[/TD]
[TD]COM[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]281,200[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CIT Apartment Complex[/TD]
[TD]COM[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]257,000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Housing Agency[/TD]
[TD]GOV[/TD]
[TD]No[/TD]
[TD]No[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]23,300[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Pinon Pizza Edge[/TD]
[TD]COM[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]81,110[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Department of Agriculture[/TD]
[TD]GOV[/TD]
[TD]No[/TD]
[TD]No[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]2,783,000[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chevron Station[/TD]
[TD]COM[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD="align: right"]2013[/TD]
[TD="align: right"]1,131,600[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL span=2></COLGROUP>[/TABLE]