Hi All

I was trying to work on a formula which determines if any decimal exist in the given range.
say A1=5.00 A2=5.32 A3=9.64 A4="" A5=0.0, it should return me false as thers decimal in A2 and A3.
=IF(SUMPRODUCT(A1:A5/ROUND(A1:A5,0))/COUNTIF(A1:A5,">=0")<>1,FALSE,TRUE)
this formula works if there's no blank or zeros in the range, how to modify to exclude zeros and blanks?

Thanks in advance