Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Scenario Condition Formula
I'm trying to Create a Formula that Wiil take the results I get, in this case
Gallons in Decimals, and display the result in the spreadsheet in Gallon and Ounces. Example 1.65 Gallons (Note The answer I get may be 2.55, 3.79 etc Gallons) I want the formula to multiply only the Decimal part of the result ~ .65 by 128 to get the Ounces and then add back to to the Full Gallon # which will vary 1, 2, 3 etc. Or if another way to do this let me Know. Thank You All |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Lookup as condition in sumproduct formula | Excel Worksheet Functions | |||
What formula/fn would I use to count multiple condition records? | Excel Worksheet Functions | |||
scenario analysis-multiple variables | Excel Worksheet Functions | |||
Multiple Condition Formula | Excel Worksheet Functions | |||
Multiple Condition Sumif Formula | Excel Worksheet Functions |