A four digit number is squared to form an eight digit number. The center four digits of that square form the four digit number. Find all possible four digit numbers.
(If 'abcd' was the four digit number, then the eight digit number would look like 'wxabcdyz'.)
(In reply to
re(2): Excel Solution by np_rt)
In Column F, you could use an IF statement like this.
IF(A1=E1,"Yes","")
And copy and paste to the bottom. You now have a "Yes" where the values are equal and otherwise you have nothing.
|
|
Posted by Michael
on 2004-11-29 05:05:42 |
re(3): Excel Solution
