Apache OpenOffice Community Forum

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.

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.

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

=ABS(A1-B1)<0.0001

DWDun wrote: ↑Sun Mar 02, 2025 12:13 am ... 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!
===

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