Hi There, Does any one know of a way/Fomula i can use to recognied whole numbers
What i need is an if sum that say..
If A1=whole number B1=Yes If not it = No
So if A1 was 4 it would be yes but 4,2 it would be no
Any thoughts?
Hi There, Does any one know of a way/Fomula i can use to recognied whole numbers
What i need is an if sum that say..
If A1=whole number B1=Yes If not it = No
So if A1 was 4 it would be yes but 4,2 it would be no
Any thoughts?
Last edited by Notters; 10-11-2012 at 07:37 AM.
Try this in B1:
=IF(A1=INT(A1),"Yes","No")
Hope this helps.
Pete
Perfect thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks