I am trying to use the function COUNTIF, to see how many numbers in a block are bigger or equal to 10. Since the block has a few cells only, I can count that there are 6. However, I wrote the function =COUNTIF(L7:L14; ">=10")
and it shows that there are only 3, which I assume is the number os cells with numbers bigger that 10 (does not include equals to 10).
Can someone help please?
I figured what the problem was. The cells contained the numbers 9,66666, for example, but were formatted to aproximate to the unit.
This is a project for school so I fixed it by changing the 10 in the formula to 9,5, I donât know if there is other way or even if I can do that xd.
Avoid any formatting that lies about content. If the cell in question (9.666) has a formula, use =ROUND(whatever). Then the displayed value reflects the actual value.
1 Like