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
|