excel returns incorrect product using basic multiplication

%3CLINGO-SUB%20id%3D%22lingo-sub-2442108%22%20slang%3D%22en-US%22%3Eexcel%20returns%20incorrect%20product%20using%20basic%20multiplication%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2442108%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20this%20discussion%20I'll%20focus%20on%20cell%20N16%20of%20the%20%22proposal%22%20page%26nbsp%3B%20The%20formula%20I%20am%20using%20links%20back%20to%20Q8*J6%20of%20the%20%22worksheet%22%20page.%20It%20is%20obviously%20calculating%20numbers%20that%20excel%20sees%20differently%20than%20it%20is%20displaying%20for%20me%20to%20see.%20In%20J5%20of%20the%20worksheet%2C%20I%20use%20the%20roundup%20formula%20and%20am%20pretty%20sure%20this%20is%20what%20is%20affecting%20my%20final%20product%20in%20N16%20on%20the%20proposal%20page.%26nbsp%3B%20I%20just%20do%20not%20know%20how%20to%20fix%20this%20so%20that%201%2C320*4.19%20%3D%205%2C530.80%26nbsp%3B%20%26nbsp%3Bas%20it%20should...%20not%205%2C535.30%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20similar%20occurrences%20in%20other%20areas%20of%20my%20spreadsheet%2C%20but%20I%20would%20think%20that%20they%20all%20suffer%20from%20the%20same%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20the%20assistance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2442108%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

For this discussion I'll focus on cell N16 of the "proposal" page  The formula I am using links back to Q8*J6 of the "worksheet" page. It is obviously calculating numbers that excel sees differently than it is displaying for me to see. In J5 of the worksheet, I use the roundup formula and am pretty sure this is what is affecting my final product in N16 on the proposal page.  I just do not know how to fix this so that 1,320*4.19 = 5,530.80   as it should... not 5,535.30

 

There are similar occurrences in other areas of my spreadsheet, but I would think that they all suffer from the same problem.

 

Thanks in advance for the assistance.

1 Reply

@Traceistumped 

As you can easily check the value of Q8 is 4.19341 and it shows 4.19 only because of the number format.