yare mare problem ya hai kay mujhay excel ki file may say decimal values ka pata chalana hai is may kuch cell may round number hai for example
100
250
523
5.23
1.0
800
900
5.6
yare mare problem ya hai kay mujhay excel ki file may say decimal values ka pata chalana hai is may kuch cell may round number hai for example
100
250
523
5.23
1.0
800
900
5.6
decemal values count karna hain ya pata karna ha k decimal hain ya whole.
Agar Pata chalana ha tu tr this. I assume a1:a10 houses data
In b1
=IF(ISNUMBER(FIND(".",A1)),"Decimal","Whole")
IN c1
=countif(b1:b10,"decimal")
Bookmarks