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

=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

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