Hello,
can anyone explain to me how the next thing is possible? I have a countif formula, which compares a cell with itself, with a "smaller or equal to" criterium.
Normally this should always result in the outcome 1. However in two cases the outcome in excel is 0. I have sketched this example below:
41557.0000150000 =COUNTIF(F15:F15,"<="&F15) 1
41557.0000150999 =COUNTIF(F16:F16,"<="&F16) 0
I do not know how this is possible. Maybe to much decimals? I hope someone can give me some explanation!
Bookmarks