| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conversion help | Excel Discussion (Misc queries) | |||
| how do i prepare a conversion chart in Excel? | Charts and Charting in Excel | |||
| CONVERSION | Excel Discussion (Misc queries) | |||
| chart conversion | Charts and Charting in Excel | |||
| combo chart conversion | Charts and Charting in Excel | |||
Linear Mode
