Convert Numbers

  • Thread starter Thread starter Norm
  • Start date Start date
N

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.
 
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
 
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
 
Back
Top