ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Gallons and % (https://www.excelbanter.com/excel-discussion-misc-queries/233005-gallons-%25.html)

Richard

Gallons and %
 
Can someone help with a formula to convert the % of gallons mixed. Example:
what is 10 % of 4 gallons
what is 10 % of 1 1/2 pounds


Bernard Liengme[_3_]

Gallons and %
 
what is 10 % of 4 gallons = 0.4 gallons { 4 * 10/100)
what is 10 % of 1 1/2 pounds = 2.4 oz {24 * 10/100)

best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Richard" wrote in message
...
Can someone help with a formula to convert the % of gallons mixed.
Example:
what is 10 % of 4 gallons
what is 10 % of 1 1/2 pounds




Jacob Skaria

Gallons and %
 
=4*10/100

=1.5*10/100

If this post helps click Yes
---------------
Jacob Skaria


"Richard" wrote:

Can someone help with a formula to convert the % of gallons mixed. Example:
what is 10 % of 4 gallons
what is 10 % of 1 1/2 pounds


Teethless mama

Gallons and %
 
Home work?


"Richard" wrote:

Can someone help with a formula to convert the % of gallons mixed. Example:
what is 10 % of 4 gallons
what is 10 % of 1 1/2 pounds


joel

Gallons and %
 
See the worksheet help menu for convert

=convert("gaL",""qt")

"Teethless mama" wrote:

Home work?


"Richard" wrote:

Can someone help with a formula to convert the % of gallons mixed. Example:
what is 10 % of 4 gallons
what is 10 % of 1 1/2 pounds


Shane Devenshire[_2_]

Gallons and %
 
Hi,

=.1*4
=.1*1.5

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Richard" wrote:

Can someone help with a formula to convert the % of gallons mixed. Example:
what is 10 % of 4 gallons
what is 10 % of 1 1/2 pounds



All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com