Oct 27 2021 02:12 AM
Hi there,
I've come across this issue, all of a sudden this morning an "IF" statement turned turtle. which was working until last night.
I'm using excel 365 online version on windows 10. I appreciate any help, Thanks in Advance
Oct 27 2021 02:39 AM
Solution@capri01 The screenshot doesn't reveal what exactly is in the two cells that you are comparing. Could be a rounding error in the 14th or 15th decimal. That happens sometimes.
Oct 27 2021 02:41 AM
@capri01 Hi, have you checked if there is some difference in both the 31000s. I mean the image you have shared does not show decimals. Try to elaborate the cell content by increasing decimal values to each of those figures. See my attachment, although both looks same there is some point difference which puts "Error" in the formula cell. I hope this helps.
Oct 27 2021 03:18 AM
Oct 27 2021 02:39 AM
Solution@capri01 The screenshot doesn't reveal what exactly is in the two cells that you are comparing. Could be a rounding error in the 14th or 15th decimal. That happens sometimes.