View Single Post
Old 05-08-2009, 06:50 AM   #11 (permalink)
instarx
EcoModding Dilatant
 
Join Date: Jul 2008
Location: NC
Posts: 262

Volvo - '00 Volvo V70 XC AWD SE
90 day: 27.7 mpg (US)
Thanks: 4
Thanked 27 Times in 17 Posts
Actually, because the multiplication has to be done before the addition I'd write it this way:

(($4.39 * 1 gallon) + ($3.99 *10.25 gallons)) / total gallons

therefore

(4.39 + 40.89) / 11.25 = $4.025

The Excel equation would be

=((4.39*1)+(3.99*10.25))/(1+10.25)

Note the double parentheses in the numerator.


Last edited by instarx; 05-08-2009 at 07:00 AM..
  Reply With Quote