chart conversion

K

Karen

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conversion chart 4
Fuel Tank Tilt vloume from fuel point in Gallons 2
converting vertical inches in tank to gallons (have manual chart) 14
can a cell be both input and output? 3
2 woorksheets 1 workbook, help with lookup 3
IF Statement 6
Excel Formula 4
Applying a formula to multiple values within a single cell? 1

Top