Thread: how do i work i pints and gallons
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default how do i work i pints and gallons
=INT(SUM(INT(A1:A10))+SUM(MOD(A1:A10,1)*10/8))+MOD(SUM(INT(A1:A10))+SUM(MOD(A1:A10,1)*10/8),1)*8/10
as an array formula (Control Shift Enter)

--
David Biddulph
Rowing web pages at
http://www.biddulph.org.uk/

boss steve wrote:
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 QuoteReply With Quote