Check how many Numbers have a decimal part > 0 in Excel

  Kiến thức lập trình

I have a large Excel table where there is a column with values as:

  E         G
person    income
------    -------
joe        100.00
frank       99.00
....

I believe all these rows got just values with .00 as decimal part. However, I need to prove it. I know that there is the function COUNTIFS that I could use to check how many numbers are > 0:

= COUNTIFS(G3:G101723, ">" & 0)

For my problem I need to test how many numbers from column G satisfy: G – TRUNC(G) > 0
for values in the rank G3:G101723

Any suggestions? Thanks in advance.

LEAVE A COMMENT