Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get my spreadsheet to give me tank gage amounts.
I have a fuel tank that is a round but is laying down ways. how do i get
excell spreadsheet to give me the correct amount of gallons in tank the if we have the correct gage in inches, with the tank being round i can not figure out how to get the sheet to give me the amount because of the graduation of the amount in the tank. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get my spreadsheet to give me tank gage amounts.
tankerman Wrote: I have a fuel tank that is a round but is laying down ways. how do i get excell spreadsheet to give me the correct amount of gallons in tank the if we have the correct gage in inches, with the tank being round i can not figure out how to get the sheet to give me the amount because of the graduation of the amount in the tank. For this simple situation, you do not really need a spreadsheet to determine the volume of the fuel in the tank. All you need is the strapping table for this tank. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=498275 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get my spreadsheet to give me tank gage amounts.
I have the strappings for the tank but how can I get the spreadsheet (we use
it for several different enteries of different products and other things) to enter the amount of fuel in one cell with the gages in another. "BenjieLop" wrote: tankerman Wrote: I have a fuel tank that is a round but is laying down ways. how do i get excell spreadsheet to give me the correct amount of gallons in tank the if we have the correct gage in inches, with the tank being round i can not figure out how to get the sheet to give me the amount because of the graduation of the amount in the tank. For this simple situation, you do not really need a spreadsheet to determine the volume of the fuel in the tank. All you need is the strapping table for this tank. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=498275 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i get my spreadsheet to give me tank gage amounts.
Take a look at the VLOOKUP function ... Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=498275 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Returning values in another spreadsheet | Excel Worksheet Functions | |||
Hyperlinking to Excel 2000 with a linked spreadsheet | Excel Discussion (Misc queries) | |||
Spreadsheet merging problems | Excel Worksheet Functions |