Forum Discussion
Solved
Conditional Number Format BUG
Excel seems to disagree with the commutative property of addition. Both cells B6 and B7 have the same conditional number formatting: [Red][<1]0%;[Blue][>1]0%;0% And the same formula except for t...
Congratulations. You just found out about the floating point error:
https://docs.microsoft.com/en-us/office/troubleshoot/access/floating-calculations-info
B6 has the value 0.99999999999999989.
B7 has the value 1.
Looks like floating point error https://docs.microsoft.com/en-us/office/troubleshoot/excel/floating-point-arithmetic-inaccurate-result in custom format handling
It was. Applying ROUND() to the adding factors worked.
Thank you for your reply SergeiBaklan
