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 |
Multiple Scenario Condition Formula
=INT(A1)&"gals "&MOD(A1,1)*128&"oz"
or =INT(A1)&"gals "&TEXT(MOD(A1,1)*128,"#")&"oz" or =INT(A1)&" "&TEXT(MOD(A1,1)*128,"#")&"/128" best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "ssmbob" wrote in message ... 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 |
Multiple Scenario Condition Formula
Your a Wizard, and Fast! ~ Don't know how much I appreciate this.
Kudos to Merlin ~ My Nickname for you. "Bernard Liengme" wrote: =INT(A1)&"gals "&MOD(A1,1)*128&"oz" or =INT(A1)&"gals "&TEXT(MOD(A1,1)*128,"#")&"oz" or =INT(A1)&" "&TEXT(MOD(A1,1)*128,"#")&"/128" best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "ssmbob" wrote in message ... 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 |
All times are GMT +1. The time now is 06:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com