Convert Numbers

[Norm]

I am measuring the amount of fuel in an 8,000 gal tank by
how many inches are in the tank and entering the "inches"
into cell 'A'. Then I have to convert it to gallons
manually by using an equation chart and enter this number
into cell 'B'. The spreadsheet then calculates the
variance between the two. I want to enter a measurement of
inches into cell 'A' and have excel automatically convert
it to a gallon measurement in cell 'B'. Is this possible?
All the data for the equation chart is entered into
individual cells within the workbook on the 4th page.

 

[Biff]

Hi Norm,

You should create a lookup table and then use the VLOOKUP
funtion in a formula.

If your equation chart data on the other sheet is already
setup in that fashion it should be relatively easy.

If the chart data is setup like this:

INCHES GALS
1 5
2 10
3 15
... ..

Inches is col A starting in A2
Gals is in col B starting in B2

In sheet1 cell A1 enter the measurement.
In cell B1 enter this formula: =VLOOKUP(A1,Sheet4!B2:C5,2)

I think this is what you're looking for. If not post back.

Biff

 

[Biff]

Hi Harlan,

I just used random numbers to show an example. But you are
correct, a direct calculation would be best if you have
the necessary data to create the equation. I used to
do 'tons' of this type of spreadsheet, but the engineers
always supplied the particulars.

Biff

 

[Biff]

P.S. - I love the quote at the very end of that thread!