I have a tank containing product. The amount of product has to be measured
every day in inches and converted to gallons according to the paper
conversion chart. I would like to enter the conversion chart in excel so
that if I enter the inch reading in cell a1, the number of gallons
automatically displays in cell b1.

example of paper chart:
1.0 inch = 10 gallons
1.5 inch = 24 gallons
2.0 inch = 37 gallons
2.5 inch = 53 gallons

I am only a novice at excel and can not figure out what formula to use to do
this.