About decimals numbers
I use a worksheet full of formulas to know what divisors a number have, but i need to see what numbers have no decimals in about 500-1000 cells.
Is there a formula whitch computer can use to see if it shows a number or not (if a number have or dont have decimals)?
Last edited by RazBoss; 03-17-2009 at 02:40 PM.
It's a plane,
No, it's a bird,
NO , it,s SuperRazBoss
=if(a1-rounddown(a1)>0,"Has Decimals","Does Not have decimals")
This will work up to .00000000000001 (13 0's) - any more than 13 0's out, Excel cannot store that number.
I help because of the Pavlovian dog that resides in the inner me...so if you are happy with the results, please add to my reputation. It helps keep me motivated!
Please mark your threads as Solved once it is solved. Check the FAQ's to see how.
Thank you very much!!!
The formula had an error in it but i've resolved it.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks