Excel Issse

Question

Excel Issse

Kayser, Md Shahidulla (kayserma) 0

Issue

Same question but doing online gives incorrect answer.

2 answers

Your answer

Answer 1

Dimple Rane 1,241

Your question is unclear. Could you please provide more details about the issue you are experiencing with Excel? Specifically, what do you mean by "doing online gives incorrect answer"? Are you referring to calculations, data syncing, or something else? More context will help in providing a precise solution.

Kayser, Md Shahidulla (kayserma) 0 Reputation points

2025-11-18T20:51:11.8333333+00:00

Online means when we open the file directly from one drive, it calculates incorrectly. But the normal in computer excel solve correctly.

Answer 2

Hendrix-C 8,165 Microsoft External Staff Moderator

Hi @Kayser, Md Shahidulla (kayserma),

Thank you for posting your question in the Microsoft Q&A forum.

Based on your sharing, I suspect the issue happened due to round values issue. In your screenshot, it seems you're doing calculations in Excel online then copying and pasting the data into Excel desktop app or viceversa. In the sheet you use for calculating formulas, the result of the formula might not be 0.002 but it's 0.002xxx and rounded to 0.002. If you use this data for further calculations, Excel will use the original result as 0.002xxx to proceed. However, when you copy paste to Excel desktop, it doesn't store the original result as 0.002xxx but only the rounded number 0.002. That's why when you use the calculation in the desktop app it returns different result.

You can see in my test sheet, both 0.002 and 0.00201 can be rounded as 0.002 but it will have different results in calculation.

User's image

Therefore, I suggest you can consider using =ROUND formula to round all calculation results to maintain the accuracy of the data in both Excel web and desktop version or when you copy paste the values to another worksheet. If possible, you can download the Excel online file so it will keep the formula for you to proceed further in Excel desktop app.

I hope the information provided proves useful. Please proceed with the outlined steps and let me know whether they resolve the issue. If not, I’ll be glad to continue working with you to find a solution.

Thank you for your patience and understanding throughout this process. Should you have any questions or need further assistance, feel free to reach out at any time.

I look forward to hearing from you.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread

Kayser, Md Shahidulla (kayserma) 0 Reputation points

2025-11-18T20:54:04.2966667+00:00
Did you check the answer gape. If you do further calculation one will be 7.5% and another one will be 30%.

I believe online excel (open from one drive) has some issue.
Hendrix-C 8,165 Reputation points Microsoft External Staff Moderator

2025-11-18T21:10:41.37+00:00

Hi @Kayser, Md Shahidulla (kayserma),

I greatly appreciate your response.

The reason why I suspect the issue happened due to round values issue is that the value of your data is small, the difference in round values can create a huge gap when calculating.

As you can see here, I try reproducing the huge gap between 7.5% and 30% as same as your screenshot. In B4 I use 0.00242, B2 is 0.00200 and both of them can be rounded as 0.002. The gap of 0.00042 may be considered small but it can make the results of two formulas having a huge difference.

If possible, can you share more details and the sample data that having issue so I can take a look and provide the most appropriate explanation for your concern.

Thank you for your patience and your understanding. Looking forward to hearing from you soon.
Kayser, Md Shahidulla (kayserma) 0 Reputation points

2025-11-18T21:15:05.51+00:00

Thanks for clarification
Hendrix-C 8,165 Reputation points Microsoft External Staff Moderator

2025-11-19T23:52:46.1933333+00:00

Good day @Kayser, Md Shahidulla (kayserma),

Hope things are running smoothly on your end.

Following up on the support thread we've been working on. I want to make sure everything is working as expected and that your experience remains uninterrupted.

Did the issue happen because of the rounded numbers difference? If you are still facing the same issue after double checking that the data is rounded correctly, kindly respond to this email, and I will be happy to help.

Thank you for your patience and understanding throughout the troubleshooting process.

I look forward to hearing from you soon.
Hendrix-C 8,165 Reputation points Microsoft External Staff Moderator

2025-11-21T23:37:49.9+00:00

Hi @Kayser, Md Shahidulla (kayserma),

I hope you are having a great day.

I'm reaching out again to follow up on your issue and check if everything has been resolved. My goal is to ensure your experience remains smooth and hassle-free. If you're still encountering any problems or have run into new challenges, please let me know which steps you're currently stuck on and happy to provide further help whenever you need it.

If you have any further questions, feel free to tag me in your reply so I can assist you directly.

Looking forward to your update.

Share via

Excel Issse

2 answers

Your answer