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?
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,
