Can someone explain why not a zero ?

Can someone explain to me this **** ?

4500,15 - 4000-500-0.15 equals 0 NOT -3.63792^-13

This is due to unavoidable tiny rounding errors, caused by the way Excel stores and processes numbers.

Since the numbers involved in your calculation have at most 2 decimal places, you should round the result to two decimal places too:

=ROUND(A1-4000-500-0.15, 2)

---
Best wishes, HansV
https://www.eileenslounge.com

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated March 12, 2023 Views 15 Applies to: