Hi, I need a formula to tell me whether a number is a square number, or I can do it so to see if the square root of a number is an interger.
So far Iv been doing
A1 = √2
A2 = AND(RIGHT(A1,1)=INT(A1))
True or false outcome is fine, and it has been working fine on some examples, but the problem comes when I have √49, as it is 2 digits long. I've seen a formula similar to find the root symbol, and look at all the numbers upto this point (maybe FIND), could some one help me to do this?
Either that or another formula would be good!
Thanks
Bookmarks