Posted to microsoft.public.excel.misc

boss steve boss steve is offline

external usenet poster

Posts: 1

how do i work i pints and gallons

i would like to have a column that works in pints and gallons that will add
up at the bottom.
so if i put in 1.4 (1 being a gallon & .4 being pints) + 2.7 (2 being a
gallon & .7 being pints) the answer i need would be 4.3
as there are 8 pints in a gallon

Using Excel 2007

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How many gallons?	Richard	Excel Discussion (Misc queries)	2	June 26th 09 09:46 PM
Convert Square Feet to Gallons	Texins Karate	Excel Worksheet Functions	4	June 9th 09 02:49 AM
Gallons and %	Richard	Excel Discussion (Misc queries)	5	June 6th 09 06:41 AM
Excel 2003, how to convert gallons to cubic feet?	Petec	Excel Worksheet Functions	6	March 3rd 09 02:53 AM
uk gallons	Reacher	New Users to Excel	3	August 9th 08 12:27 AM

All times are GMT +1. The time now is 05:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us