Quick question.. Anyone know if there's a way to set an If statement to check to see if a number is an integer?
Rather than try to explain in prose, let me give a simple example formula. What I'm trying to do is basically this: =if(A1/B$5$=[Integer],1,0)
Seems like there should be a way to do it, but the arithmetic formulas (ABS, INT) are designed to create integers, not check for them.
Thoughts??
How about?
=if(A1/B$5$=INT(A1/B$5$),1,0)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
OR:
=If(MOD(A1/B$5,1)=0,1,0)
or just simpley
=--(MOD(A1/B$5,1)=0)
Yup... Should work fine. Probably should have thought of that myself.
Thanks for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks