[Solved] Calculated % in one cell <> identical % Etered in another cell

[DWDun]

Is there a secret to getting a return of TRUE when testing for equality between a calculated percent in one cell and an identical entered percent in another cell? Both cells have the same formatting, the only difference is one is a keyboard entry, one is the result of a calculation. Puzzling.

[Hagar Delest]

If the 2 cells are for example A1 and B1, try:
=A1=B1

If it doesn't work, please upload a sample file to show what is the context exactly.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the ✎ button if your issue has been fixed.

[floris v]

If Hagar Delest's method doesn't work (might be because of different rounding), try =(A1-B1) < 0.0001 or another small number.

[Alex1]

=ABS(A1-B1)<0.0001

[Lupp]

... Both cells have the same formatting, the only difference is one is a keyboard entry, one is the result of a calculation...

@Alex1 already showed a possible way to a solution.
Pointing out the central fact: Rounding isn't done by formatting, but -where needed- with the help of the ROUND() function. Formatting only does something like rounding for the view without changing the value of the cell it's applied to.
===
If somebody tells you that there is an option "Precision as shown": don't enable it. It comes with lots of disadvantages!
===

aoo112552RoundingRatiosShownAsPercentages.ods

(12.59 KiB) Downloaded 52 times

[DWDun]

Problem SOLVED. It was the rounding that was the problem. Thank you for your help.