excel spreadsheet not multiplying correctly

%3CLINGO-SUB%20id%3D%22lingo-sub-3387320%22%20slang%3D%22en-US%22%3Eexcel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3387320%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20multiplying%20a%20column%20with%20square%20feet%20with%20a%20column%20with%20a%20dollar%20figure%20and%20the%20answer%20is%20incorrect%20when%20checked%20with%20a%20calculator.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20cannot%20figure%20out%20why%20this%20is%20happening.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3387320%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3387502%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3387502%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1392570%22%20target%3D%22_blank%22%3E%40shawv921%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20typed%20the%20wrong%20numbers%20into%20the%20calculator.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3387567%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3387567%22%20slang%3D%22en-US%22%3Esorry%3CBR%20%2F%3EI%20am%20multiplying%20a%20column%20with%20%2413.77%20with%20a%20column%20that%20has%201015%20square%20feet%20to%20get%20the%20total%20cost%20of%20the%20square%20footage.%20the%20answer%20in%20Excel%20is%20%2413%2C973.13.%20My%20calculator%20has%20%2413976.55.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3387580%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3387580%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1392570%22%20target%3D%22_blank%22%3E%40shawv921%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20gives%20the%20same%20number%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20332px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F372400iCB158DC4A7DE08B6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3387649%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3387649%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1392570%22%20target%3D%22_blank%22%3E%40shawv921%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20most%20likely%20explanation%20is%20that%20either%2013.17%20is%20not%20%3CEM%3Eexactly%3C%2FEM%3E%20equal%20to%2013.17%2C%20or%201015%20is%20not%20%3CEM%3Eexactly%3C%2FEM%3E%20equal%20to%201015%20(or%20both).%3C%2FP%3E%0A%3CP%3ESelect%20the%20cells%20with%20these%20values%20and%20format%20them%20as%20Number%20with%2015%20decimal%20places.%20What%20do%20you%20see%3F%20(You%20may%20have%20to%20widen%20the%20columns%20they're%20in%20to%20see%20the%20full%20result)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3387676%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3387676%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20that%20could%20not%20explain%20this%20magnitude%20of%20difference.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3387725%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3387725%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDid%20you%20see%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1392570%22%20target%3D%22_blank%22%3E%40shawv921%3C%2FA%3E's%20reply%20with%20a%20correction%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3387811%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3387811%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20348px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F372414i8FC43DF404649C6A%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3387871%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3387871%22%20slang%3D%22en-US%22%3EI%20don't%20understand%20what%20you%20are%20showing%20me%20in%20the%20row.%3CBR%20%2F%3ERow%202%20has%20the%20correct%20answer%3CBR%20%2F%3ERow%203%20has%20the%20incorrect%20answer%20in%20my%20spread%20sheet.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3388017%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3388017%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAh%2C%20missed%20that%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3388022%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3388022%22%20slang%3D%22en-US%22%3EI%20changed%20the%20sq.%20ft.%20values%20to%20numbers%20with%2015%20decimal%20places.%3CBR%20%2F%3EI%20changed%20the%20cost%20per%20sq.%20ft.%20to%20numbers%20with%2015%20decimal%20places.%3CBR%20%2F%3EI%20changed%20the%20cost%20per%20sq.%20ft%20to%20numbers%20with%2015%20decimal%20places.%3CBR%20%2F%3Ein%20my%20shared%20spread%20sheet%20I%20have%20listed%20the%20calculator%20answers%20and%20what%20the%20cost%20per%20sq.%20ft.%20should%20be.%3CBR%20%2F%3EI%20have%20a%20feeling%20it%20is%20my%20desired%205.33%20percentage%20increase%20that%20is%20messing%20things%20up%3F%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3388035%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3388035%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1392570%22%20target%3D%22_blank%22%3E%40shawv921%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20C3%20we%20have%20number%26nbsp%3B13.7666305418719%20which%20is%20shown%20as%2013.77%20due%20to%20format%20applied.%20You%20may%20check%20what%20are%20numbers%20actually%20are%20applying%20General%20format%20(or%20Number%20with%2015%20digits)%20and%20wider%20the%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3388058%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3388058%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1392570%22%20target%3D%22_blank%22%3E%40shawv921%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E5.33%20percentage%20is%20something%20new%20here.%20Perhaps%20you%20may%20share%20how%20exactly%20you%20receive%2013.77%20(by%20formula%20and%20which%20one%2C%20or%20manually%20entered).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3388059%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3388059%22%20slang%3D%22en-US%22%3EI%20am%20not%20sure%20if%20you%20can%20see%20my%20changes%20on%20my%20spread%20sheet.%20do%20I%20need%20to%20share%20it%20again%3F%3CBR%20%2F%3EI%20have%20reformatted%20the%20columns%20to%20numbers%20%2B%2015%20decimals.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3388065%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3388065%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1392570%22%20target%3D%22_blank%22%3E%40shawv921%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%22share%20it%20again%3F%22%20-%20sorry%2C%20I%20see%20no%20file%20shared.%20That%20will%20be%20perfect%20if%20you%20share%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3388073%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3388073%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Fplacercoe1-my.sharepoint.com%2Fpersonal%2Fmshawver_placercoe_org%2FDocuments%2Fspreadsheet%2520troubleshooting.xlsx%3Fweb%3D1%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fplacercoe1-my.sharepoint.com%2Fpersonal%2Fmshawver_placercoe_org%2FDocuments%2Fspreadsheet%2520troubleshooting.xlsx%3Fweb%3D1%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3387555%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3387555%22%20slang%3D%22en-US%22%3EI%20am%20multiplying%20a%20column%20with%20%2413.77%20with%20a%20column%20that%20has%201015%20square%20feet%20to%20get%20the%20total%20cost%20of%20the%20square%20footage.%20the%20answer%20in%20Excel%20is%20123%2C973.13.%20My%20calculator%20has%20%2413976.55.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3388402%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spreadsheet%20not%20multiplying%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3388402%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1392570%22%20target%3D%22_blank%22%3E%40shawv921%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20cannot%20access%20that%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I am multiplying a column with square feet with a column with a dollar figure and the answer is incorrect when checked with a calculator. 

I cannot figure out why this is happening. 

17 Replies

@shawv921 

You typed the wrong numbers into the calculator.

 

I am multiplying a column with $13.77 with a column that has 1015 square feet to get the total cost of the square footage. the answer in Excel is 123,973.13. My calculator has $13976.55.
sorry
I am multiplying a column with $13.77 with a column that has 1015 square feet to get the total cost of the square footage. the answer in Excel is $13,973.13. My calculator has $13976.55.

@shawv921 

Excel gives the same number

image.png

@shawv921 

The most likely explanation is that either 13.17 is not exactly equal to 13.17, or 1015 is not exactly equal to 1015 (or both).

Select the cells with these values and format them as Number with 15 decimal places. What do you see? (You may have to widen the columns they're in to see the full result)

@Hans Vogelaar 

But that could not explain this magnitude of difference.

 

@Detlef Lewin 

Did you see @shawv921's reply with a correction?

I don't understand what you are showing me in the row.
Row 2 has the correct answer
Row 3 has the incorrect answer in my spread sheet.

@Hans Vogelaar 

Ah, missed that one.

 

I changed the sq. ft. values to numbers with 15 decimal places.
I changed the cost per sq. ft. to numbers with 15 decimal places.
I changed the cost per sq. ft to numbers with 15 decimal places.
in my shared spread sheet I have listed the calculator answers and what the cost per sq. ft. should be.
I have a feeling it is my desired 5.33 percentage increase that is messing things up?

@shawv921 

In C3 we have number 13.7666305418719 which is shown as 13.77 due to format applied. You may check what are numbers actually are applying General format (or Number with 15 digits) and wider the column.

@shawv921 

5.33 percentage is something new here. Perhaps you may share how exactly you receive 13.77 (by formula and which one, or manually entered).

I am not sure if you can see my changes on my spread sheet. do I need to share it again?
I have reformatted the columns to numbers + 15 decimals.

@shawv921 

"share it again?" - sorry, I see no file shared. That will be perfect if you share it.

@shawv921 

We cannot access that workbook.