This is what I need to do: Use the Lookup table in cells E2:H3 of the billing rate worksheet and the HLOOKUP function to modify the formula to calculate the water bill column H.
<TBODY>
</TBODY><COLGROUP><COL span=4></COLGROUP>
Type</SPAN> | Com</SPAN> | NPROFIT</SPAN> | GOV</SPAN> |
Bill Rate </SPAN> | $ 3.00 </SPAN> | $ 2.00 </SPAN> | $ 1.50 </SPAN> |
<TBODY>
</TBODY><COLGROUP><COL span=4></COLGROUP>