Gallon Fuel Cell



JAZ fuel cell 15 x 17 x 10 Foam filled 12 gallons
JAZ fuel cell 15 x 17 x 10 Foam filled 12 gallons
US $102.25
INCA  MARINE 12 GALLON BOAT FUEL/GAS CELL  WITH NEW SENDER & PICK UP AND HOSE
INCA MARINE 12 GALLON BOAT FUEL/GAS CELL WITH NEW SENDER & PICK UP AND HOSE
US $172.00
New Jaz 32 Gallon IMCA Steel Can Fuel Cell w/ Flapper
New Jaz 32 Gallon IMCA Steel Can Fuel Cell w/ Flapper
US $279.99
Fuel Cell Fuel Safe Legend Baby Grand Allison 5 Gallon
Fuel Cell Fuel Safe Legend Baby Grand Allison 5 Gallon
US $100.00
Summit Racing Drag Race Fuel Cell 5 Gallon Plastic Black
Summit Racing Drag Race Fuel Cell 5 Gallon Plastic Black
US $104.90
ATL 18 Gallon Fuel Cell Complete~ Road Course ~ IN DATE
ATL 18 Gallon Fuel Cell Complete~ Road Course ~ IN DATE
US $799.95
RCI 1010D 1-Gallon Drag Race Fuel Cell without Foam, 6'' x 6'' x 12''
RCI 1010D 1-Gallon Drag Race Fuel Cell without Foam, 6'' x 6'' x 12''
US $98.98
JAZ Products 250-004-01 DR 4-Gallon Vertical Fuel Cell
JAZ Products 250-004-01 DR 4-Gallon Vertical Fuel Cell
US $148.98
RCI 2080D 8-Gallon Drag Race Fuel Cell with Foam, 17'' x 17'' x 8''
RCI 2080D 8-Gallon Drag Race Fuel Cell with Foam, 17'' x 17'' x 8''
US $179.98
JAZ Products 210-620-03 20-Gallon Aluminum Fuel Cell
JAZ Products 210-620-03 20-Gallon Aluminum Fuel Cell
US $336.98
JAZ 210-503-03 Aluminum Fuel Cell 3 Gallon 8
JAZ 210-503-03 Aluminum Fuel Cell 3 Gallon 8" x 8" x 15"
US $165.88
JAZ 210-520-03 Aluminum Fuel Cell 20 Gallon 24
JAZ 210-520-03 Aluminum Fuel Cell 20 Gallon 24" x 20" x 10"
US $289.88
JAZ 290-104-01 Econo Rail Fuel Cell 4 Gallon 12
JAZ 290-104-01 Econo Rail Fuel Cell 4 Gallon 12" x 12.5" x 8.5"
US $141.88
JAZ 250-016-01 Drag Race Fuel Cell 16 Gallon 25
JAZ 250-016-01 Drag Race Fuel Cell 16 Gallon 25" x 17" x 9"
US $177.88
JAZ 210-614-03 Aluminum Fuel Cell 14 Gallon 0-90 Ohm Sender 30
JAZ 210-614-03 Aluminum Fuel Cell 14 Gallon 0-90 Ohm Sender 30" x 9.5" x 12.25"
US $279.88
JAZ 210-510-03 Aluminum Fuel Cell 10 Gallon 17
JAZ 210-510-03 Aluminum Fuel Cell 10 Gallon 17" x 17" x 9"
US $222.88
ATL 171110 WELL CELL SUPER SAVER FUEL CELL 12 GALLON
ATL 171110 WELL CELL SUPER SAVER FUEL CELL 12 GALLON
US $458.22
Mirax Fuel Cell, Fuel tank, 15 gallon, racing or hot rod tank
Mirax Fuel Cell, Fuel tank, 15 gallon, racing or hot rod tank
US $25.00
JAZ 1 Gallon Fuel Cell 250-001-01 and Mounts 400-001-03 BRAND NEW! Package Deal
JAZ 1 Gallon Fuel Cell 250-001-01 and Mounts 400-001-03 BRAND NEW! Package Deal
US $99.99
BD Racing 5 Gallon Pro Series Aluminum Fuel Cell Magnafuel Weldon Aeromotive AED
BD Racing 5 Gallon Pro Series Aluminum Fuel Cell Magnafuel Weldon Aeromotive AED
US $154.95
BD Racing 15 Gallon Pro Series Aluminum Fuel Cell Magnafuel Weldon Aeromotive AE
BD Racing 15 Gallon Pro Series Aluminum Fuel Cell Magnafuel Weldon Aeromotive AE
US $194.95
BD Racing 10 Gallon Pro Series Aluminum Fuel Cell Magnafuel Weldon Aeromotive AE
BD Racing 10 Gallon Pro Series Aluminum Fuel Cell Magnafuel Weldon Aeromotive AE
US $174.95
BD Racing 20 Gallon Pro Series Aluminum Fuel Cell Magnafuel Weldon Aeromotive AE
BD Racing 20 Gallon Pro Series Aluminum Fuel Cell Magnafuel Weldon Aeromotive AE
US $219.95
ATL 32 Gallon Dirt Late Model Racing Fuel Cell
ATL 32 Gallon Dirt Late Model Racing Fuel Cell
US $660.50
JEGS Performance Products 15332 15-Gallon Fuel Cell
JEGS Performance Products 15332 15-Gallon Fuel Cell
US $215.08
RCI 2160D 16-Gallon Drag Race Fuel Cell with Foam, 23'' x 17'' x 11''
RCI 2160D 16-Gallon Drag Race Fuel Cell with Foam, 23'' x 17'' x 11''
US $187.98
JAZ Products 22 Gallon Fuel Cell
JAZ Products 22 Gallon Fuel Cell
US $125.00
ATL DLM Sports Cell Fuel Cell 32 Gallons Red 26.12
ATL DLM Sports Cell Fuel Cell 32 Gallons Red 26.12"x19"x17.25" Steel
US $962.40
ATL Sports Cell Fuel Cell 22 Gallons Red 25.13
ATL Sports Cell Fuel Cell 22 Gallons Red 25.13"x16.75"x13.75" Steel
US $857.90
ATL DLM Sports Cell Fuel Cell 26 Gallons Red 25.25
ATL DLM Sports Cell Fuel Cell 26 Gallons Red 25.25"x16.85"x17.25" Steel
US $828.40
ATL Super Cell 100 Series Fuel Cell 22 Gallons Red 33
ATL Super Cell 100 Series Fuel Cell 22 Gallons Red 33"x17"x9.25" Steel
US $1,125.94
Jaz Vertical 1 Gallon Fuel Cell Jr. Dragster Nitrous Drag Race JAZ 250-001-01
Jaz Vertical 1 Gallon Fuel Cell Jr. Dragster Nitrous Drag Race JAZ 250-001-01
US $99.99
ATL 28 Gallon Sprint Cell, Fuel Safe Style
ATL 28 Gallon Sprint Cell, Fuel Safe Style
US $1,625.00
Jaz 16 gallon Fuel cell Gas tank Fuel safe Foam
Jaz 16 gallon Fuel cell Gas tank Fuel safe Foam
US $419.99
Jaz 220-002-NF5 Fuel Cell Pro Sport Plastic Natural 2 Gallons Each
Jaz 220-002-NF5 Fuel Cell Pro Sport Plastic Natural 2 Gallons Each
US $287.90
12 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW RCI 2121A
12 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW RCI 2121A
US $139.28
15 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW RCI 2162A
15 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW RCI 2162A
US $152.50
17 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW RCI 2172A
17 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW RCI 2172A
US $280.00
1 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing  NEW RCI 2010A
1 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW RCI 2010A
US $110.00
20 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street  Racing  NEW 2200AS
20 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW 2200AS
US $290.00
20 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street  Racing  NEW 2201AS
20 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW 2201AS
US $290.00
10 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing  NEW 2100AS
10 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW 2100AS
US $240.00
15 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street  Racing  NEW 2150AS
15 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW 2150AS
US $260.00
15 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street  Racing  NEW 2151AS
15 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW 2151AS
US $260.00
15 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW RCI 2161A
15 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW RCI 2161A
US $152.05
17 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW RCI 2171A
17 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW RCI 2171A
US $280.00
19 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW RCI 2191A
19 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW RCI 2191A
US $290.00
3 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing  NEW RCI 2030A
3 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW RCI 2030A
US $140.00
4 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing  NEW RCI 2040A
4 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW RCI 2040A
US $150.00
5 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing  NEW RCI 2050A
5 Gallon RCI Fuel Cell Gas Tank Aluminum Heavy Duty Street Racing NEW RCI 2050A
US $160.00
JAZ 220-003-01 Pro Modified Fuel Cell 3 Gallon 8.25
JAZ 220-003-01 Pro Modified Fuel Cell 3 Gallon 8.25" x 8.25" x 14.5"
US $281.88
JAZ 220-303-01 Pro Stock Fuel Cell 3 Gallon 8
JAZ 220-303-01 Pro Stock Fuel Cell 3 Gallon 8" x 8" x 15"
US $269.88
JAZ 220-002-01 Pro Stock Fuel Cell 2 Gallon 7
JAZ 220-002-01 Pro Stock Fuel Cell 2 Gallon 7" x 9" x 10"
US $268.88
JAZ 400-002-03 Fuel Cell Mounts Steel For JAZ 2 Gallon 002 Fuel Cell
JAZ 400-002-03 Fuel Cell Mounts Steel For JAZ 2 Gallon 002 Fuel Cell
US $36.88
JAZ 250-105-01 Drag Race Fuel Cell 5 Gallon 9
JAZ 250-105-01 Drag Race Fuel Cell 5 Gallon 9" x 11" x 18"
US $168.88
CYMAT FUEL CELL BLOCK SET 13 GALLON NASCAR RACING NEW
CYMAT FUEL CELL BLOCK SET 13 GALLON NASCAR RACING NEW
US $750.00
CYMAT FUEL CELL BLOCK SET 13 GALLON NASCAR RACING NEW ARCA
CYMAT FUEL CELL BLOCK SET 13 GALLON NASCAR RACING NEW ARCA
US $750.00
ATL SU112 12 GALLON SUPER CELL FUEL CELL FT3 RATED
ATL SU112 12 GALLON SUPER CELL FUEL CELL FT3 RATED
US $855.55
ATL SU117 17 GALLON SUPER CELL FUEL CELL FT3 RATED
ATL SU117 17 GALLON SUPER CELL FUEL CELL FT3 RATED
US $991.89
ATL SU115 15 GALLON SUPER CELL FUEL CELL FT3 RATED
ATL SU115 15 GALLON SUPER CELL FUEL CELL FT3 RATED
US $875.85
ATL SA110 10 GALLON SAVER CELL DIY FUEL CELL SCCA VINTAGE
ATL SA110 10 GALLON SAVER CELL DIY FUEL CELL SCCA VINTAGE
US $386.46
ATL SU122 22 GALLON SUPER CELL FUEL CELL
ATL SU122 22 GALLON SUPER CELL FUEL CELL
US $1,021.82
ATL SU110 10 GALLON SUPER CELL FUEL CELL FT3 RATED
ATL SU110 10 GALLON SUPER CELL FUEL CELL FT3 RATED
US $815.08
New RCI 22 Gallon Steel Fuel Cell w Bladder/Flapper Red
New RCI 22 Gallon Steel Fuel Cell w Bladder/Flapper Red
US $209.99
New RCI 16 Gallon Steel Fuel Cell w Bladder/Flapper Red
New RCI 16 Gallon Steel Fuel Cell w Bladder/Flapper Red
US $199.99
New RCI 12 Gallon Steel Fuel Cell, Red
New RCI 12 Gallon Steel Fuel Cell, Red
US $189.99
RCI 16 Gallon Horizontal Fuel Cell Mounting Kit
RCI 16 Gallon Horizontal Fuel Cell Mounting Kit
US $45.99
RCI 32 Gallon Circle Track Fuel Cell With Can 18x26x18
RCI 32 Gallon Circle Track Fuel Cell With Can 18x26x18
US $213.84
RCI Fuel Cell Dirt Works 32 Gallon Teardrop Circletrack
RCI Fuel Cell Dirt Works 32 Gallon Teardrop Circletrack
US $235.71
RCI 32 Gallon Circle Track Fuel Cell & White Can IMCA
RCI 32 Gallon Circle Track Fuel Cell & White Can IMCA
US $212.60
RCI 32 Gallon Circle Track Fuel Cell With Can 26X18X18
RCI 32 Gallon Circle Track Fuel Cell With Can 26X18X18
US $249.99
RCI 22 Gallon Teardrop Fuel Cell Hot Chassis with Can
RCI 22 Gallon Teardrop Fuel Cell Hot Chassis with Can
US $235.71
RCI 16 Gallon Circle Track Fuel Cell with Can 25X19X11
RCI 16 Gallon Circle Track Fuel Cell with Can 25X19X11
US $172.53
NEW RCI 16 Gallon Drag Race Fuel Cell with Sending Unit
NEW RCI 16 Gallon Drag Race Fuel Cell with Sending Unit
US $211.00
RCI 16 Gallon Drag Race Fuel Cell 23X17X11 -8 AN Outlet
RCI 16 Gallon Drag Race Fuel Cell 23X17X11 -8 AN Outlet
US $159.89
RCI 12 Gallon Drag Race Fuel Cell -8AN and Sending Unit
RCI 12 Gallon Drag Race Fuel Cell -8AN and Sending Unit
US $189.99
RCI 1120D 12 Gallon Plastic Fuel Cell -8 AN Drag Race
RCI 1120D 12 Gallon Plastic Fuel Cell -8 AN Drag Race
US $157.95
Jaz Products Pro Sport Fuel Cell 8 Gallon Red Powdercoated 270-008-NF
Jaz Products Pro Sport Fuel Cell 8 Gallon Red Powdercoated 270-008-NF
US $188.90
RCI Aluminum Fuel Cell Tank Racing 15 Gallon 0-90 Fuel Sender
RCI Aluminum Fuel Cell Tank Racing 15 Gallon 0-90 Fuel Sender
US $253.90
Jaz Products Pro Sport Fuel Cell 32 Gallon White Powdercoated 270-332-NF5
Jaz Products Pro Sport Fuel Cell 32 Gallon White Powdercoated 270-332-NF5
US $340.44
Powered by phpBay Pro



Gallon Fuel Cell
Question about rounding with Excel formulas?

At work, we have a spreadsheet set up for our drivers to enter their trip information into. The cell where they enter the gallons of fuel that were purchased is set up to round as necessary so it shows an even amount of gallons. Of course, the total at the bottom adds up the actual amounts and rounds that number as necessary. The driver enters 1.1, 1.2, and 1.3 gallons into the spreadsheet on different lines. The spreadsheet will display 1 gallon on each line which is what would be entered into our fuel tax software. The total, however, will show as 4 gallons since these add up to 3.6. When we add up the totals on the trip reports and try to balance them back to the total from the software, there is always a little difference due to the rounding. I have been asked to fix this spreadsheet so that the total will show the total of the actual numbers displayed. In the example I gave the total should say 3 instead of 4. How do I or can I do that?

Using your numbers:

Let's say the numbers are in column A
A1 = 1.1
A2 = 1.2
A3 = 1.3
A4 = 3.6
If you want the number to be 3, then use the rounddown formula

put this in Cell A4 instead of the regular sum formula:
=ROUNDDOWN(SUM(A1:A3),0)



Items Recently Purchased From This Site:

BD Racing 19 Gallon Aluminum Street Series Fuel Cell W/ 240-33 Ohm Sending Unit, BD Racing 17 Gallon Aluminum Street Series Fuel Cell W/ 240-33 Ohm Sending Unit, BD Racing 17 Gallon Aluminum Street Series Fuel Cell W/ 240-33 Ohm Sending Unit, BD Racing 15 Gallon Aluminum Street Series Fuel Cell W/ 240-33 Ohm Sending Unit, BD Racing 15 Gallon Aluminum Street Series Fuel Cell W/ 240-33 Ohm Sending Unit, BD Racing 12 Gallon Aluminum Street Series Fuel Cell W/ 240-33 Ohm Sending Unit, BD Racing 20 Gallon Aluminum Flat Bottom Fuel Cell With 240-33 Ohm Sending Unit, BD Racing 20 Gallon Custom Aluminum Fuel Cell W/ Sump 240-33 Ohm Sending Unit , BD Racing 15 Gallon Custom Aluminum Fuel Cell W/ Sump 240-33 Ohm Sending Unit , BD Racing 15 Gallon Aluminum Flat Bottom Fuel Cell With 240-33 Ohm Sending Unit, BD Racing 10 Gallon Custom Aluminum Fuel Cell W/ Sump 240-33 Ohm Sending Unit , BD Racing 10 Gallon Aluminum Flat Bottom Fuel Cell With 240-33 Ohm Sending Unit, BD Racing 10 Gallon Pro Series Aluminum Fuel Cell W/ 240-33 Ohm Sending Unit, BD Racing 15 Gallon Pro Series Aluminum Fuel Cell W/ 240-33 Ohm Sending Unit, BD Racing 20 Gallon Pro Series Aluminum Fuel Cell W/ 240-33 Ohm Sending Unit, BD Racing 20 Gallon Pro Series Aluminum Fuel Cell W/ 70-10 Ohm Ford Sending Unit, BD Racing 20 Gallon Pro Series Aluminum Fuel Cell - 70-10 Ohm Mopar Sending Unit, BD Racing 20 Gallon Pro Series Aluminum Fuel Cell W/ 0-90 Ohm GM Sending Unit, BD Racing 15 Gallon Pro Series Aluminum Fuel Cell W/ 0-90 Ohm GM Sending Unit, BD Racing 15 Gallon Pro Series Aluminum Fuel Cell W/ 70-10 Ohm Ford Sending Unit, BD Racing 15 Gallon Pro Series Aluminum Fuel Cell - 70-10 Ohm Mopar Sending Unit, BD Racing 10 Gallon Pro Series Aluminum Fuel Cell W/ 70-10 Ohm Ford Sending Unit, BD Racing 10 Gallon Pro Series Aluminum Fuel Cell - 70-10 Ohm Mopar Sending Unit, BD Racing 10 Gallon Pro Series Aluminum Fuel Cell W/ 0-90 Ohm GM Sending Unit, ATL SP122B-LM-B Fuel Cell Steel Black 22 Gallons 16.75" x 23.13" x 13.75" Each, 32 Gallon 1994 ATL Fuel Cell, VINTAGE FUEL CELL Measuring Stick US Gallon FUEL TANK GAS STATION TRUCK CAR RARE, Summit Fuel Cell Mounts Steel for Summit 12-Gallon Horizontal Fuel Cell Pr, Jaz Products Pro Modified Fuel Cell 3 Gallon Plastic Black, Summit Racing Aluminum Fuel Cell Tank 10 Gallon,
Powered by phpBay Pro

Tags: , , , , , , , , ,

Leave a Comment

No comments yet.

Leave a Reply

You must be logged in to post a comment.