Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003, how to convert gallons to cubic feet? | Excel Worksheet Functions | |||
converting vertical inches in tank to gallons (have manual chart) | Excel Worksheet Functions | |||
uk gallons | New Users to Excel | |||
Calculate needed gallons of water, based on weight of person | Excel Worksheet Functions | |||
Function To Convert Liters To Imperial Gallons & Vice Versa | Excel Worksheet Functions |