SOLVED

"IF" Statement Strange behavior

%3CLINGO-SUB%20id%3D%22lingo-sub-2889601%22%20slang%3D%22en-US%22%3E%22IF%22%20Statement%20Strange%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2889601%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3EI've%20come%20across%20this%20issue%2C%20all%20of%20a%20sudden%20this%20morning%20an%20%22IF%22%20statement%20turned%20turtle.%20which%20was%20working%20until%20last%20night.%3C%2FP%3E%3CP%3EI'm%20using%20excel%20365%20online%20version%20on%20windows%2010.%20I%20appreciate%20any%20help%2C%20Thanks%20in%20Advance%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2889601%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2889724%22%20slang%3D%22en-US%22%3ERe%3A%20%22IF%22%20Statement%20Strange%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2889724%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1197275%22%20target%3D%22_blank%22%3E%40capri01%3C%2FA%3E%26nbsp%3BThe%20screenshot%20doesn't%20reveal%20what%20exactly%20is%20in%20the%20two%20cells%20that%20you%20are%20comparing.%20Could%20be%20a%20rounding%20error%20in%20the%2014th%20or%2015th%20decimal.%20That%20happens%20sometimes.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2889729%22%20slang%3D%22en-US%22%3ERe%3A%20%22IF%22%20Statement%20Strange%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2889729%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1197275%22%20target%3D%22_blank%22%3E%40capri01%3C%2FA%3E%26nbsp%3BHi%2C%20have%20you%20checked%20if%20there%20is%20some%20difference%20in%20both%20the%2031000s.%20I%20mean%20the%20image%20you%20have%20shared%20does%20not%20show%20decimals.%20Try%20to%20elaborate%20the%20cell%20content%20by%20increasing%20decimal%20values%20to%20each%20of%20those%20figures.%20See%20my%20attachment%2C%20although%20both%20looks%20same%20there%20is%20some%20point%20difference%20which%20puts%20%22Error%22%20in%20the%20formula%20cell.%20I%20hope%20this%20helps.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2889824%22%20slang%3D%22en-US%22%3ERe%3A%20%22IF%22%20Statement%20Strange%20behavior%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2889824%22%20slang%3D%22en-US%22%3Ethe%20difference%20was%20in%20the%2010th%20decimal.%20but%20since%20we%20are%20not%20using%20any%20decimals.%20it%20really%20startled%20me.%20(All%20our%20inputs%20are%20rounded%20figures%20not%20a%20single%20division%20or%20a%20%25age%20I%20am%20still%20wondering%20where%20did%20.0000000001%20came%20from%3F%20Anyhow%20I%20have%20rounded%20it%20up%20for%20the%20time%20being..%20I%20will%20investigate%20more%20.%3CBR%20%2F%3Ea%20big%20thanks%20to%20you%20and%20Riny_van_Eekelen%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

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 

3 Replies
best response confirmed by capri01 (New Contributor)
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.

@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.

the difference was in the 10th decimal. but since we are not using any decimals. it really startled me. (All our inputs are rounded figures not a single division or a %age I am still wondering where did .0000000001 came from? Anyhow I have rounded it up for the time being.. I will investigate more .
a big thanks to you and Riny_van_Eekelen