How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask The-PC-Guy Your Own Question
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1964
Experience:  20 years experience providing remote computer support
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

In my excel spreadsheet I am calculating simply math (multiplying

Customer Question

In my excel spreadsheet I am calculating simply math (multiplying 2 cells). Excel is calculating 45 x $4.50 as $202.32 instead of $202.50 and 85 x 9.50 as $807.84 rather than $807.50. Yet it calculates 45 x $10.76 as $484.20 which of course is correct.

Same formulas in all cells; just that some cells come up with correct answers; others do not.

I have double checked formatting in all cells (I formatted the entire column).

Submitted: 4 years ago.
Category: Microsoft Office
Expert:  The-PC-Guy replied 4 years ago.
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question !

Is it possible for you to upload a copy of the worksheet to

after uploading you will be given a file ID# XXXXX a download link I will need either one to download it. I will take a look and see what I can do to fix it.
Customer: replied 4 years ago.

251466 FB_11 01_DD.xlsx



Expert:  The-PC-Guy replied 4 years ago.
Sorry for the delayed response I got caught up in something.

ok I was able to figure out what is going on. It is due to rounding error.

When you apply formatting in excel it only changes the way the cell looks and does not effect the underlying calculation. Excel will calculate all decimals automatically.

5.62 * .20 is actually 1.124 and when multiplying that by 45 you will get a different value then 1.12 * 45.

To correct this you will have to use the round function, and round the number in column H before multiplying it to column F to get the answer you are looking for. I changed the first few cells in Column H to give you an idea of how this function works.

you can download that here FB_11 01_DD-fixed.xlsx

Don't Forget the deposit you placed to ask this question is not used to compensate
me until you rate my service! Please Remember that when you are asked to give a
rating, you are rating My Service and not this website itself or your device

"If you have any other questions don't hesitate to ask, and please don't forget to
rate my service to you below ."


if you have any questions in the future you can visit my profile

and ask a question right in my box,

also you can put "PC Guy only" in your question title if you want to get to me.
Expert:  The-PC-Guy replied 4 years ago.



Please tell me why you rated me negativelly? What is wrong? Can you please correct to positive rating?


Please click continue conversation with expert so we can correct the situation.

Related Microsoft Office Questions