chart conversion
 

I have a paper conversion chart for a tank. It lists inches and shows how
many gallons of product is in the tank according to the inches.

so if I enter the number of inches in cell a1, I want cell b1 to look up on
the chart and display the number of gallons

if I enter 1 in cell a1, then cell b2 would look up on the chart and display
100 (1 inch representing 100 gallons). would like to be able to enter the
conversions for all 70 inches. I just can't figure out how to do the formula.

Thanks to anyone that can help.

chart conversion
 

=A1*100


"Karen" wrote:

I have a paper conversion chart for a tank. It lists inches and shows how
many gallons of product is in the tank according to the inches.

so if I enter the number of inches in cell a1, I want cell b1 to look up on
the chart and display the number of gallons

if I enter 1 in cell a1, then cell b2 would look up on the chart and display
100 (1 inch representing 100 gallons). would like to be able to enter the
conversions for all 70 inches. I just can't figure out how to do the formula.

Thanks to anyone that can help.