• Ask an Expert
• Get a Professional Answer
• 100% Satisfaction Guarantee
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1938
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now

# 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).

Help!
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 www.wikisend.com

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

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.

-----------------------------------------------------------------------
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.

Kathy?

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.