Forum Discussion
Cell Value Comparison
Hi, Please can someone help me as I am tearing my hair out right now and Copilot AI is obsessed with header rows and no help at all. I have a spreadsheet with a load of numbers on it and various co...
Both AC4 and X4 are not empty, thus we have AC4-X4. Most probably values in these cells are not rounded, e.g. in X4 we have 128.8002 and in AC4 128.8001. Difference is -0.0001. Applying currency format which shows 2 decimals we see -0.00.
If you'd like to have exact zero it shall be like ROUND(AC4,2) - ROUND(X4,2).