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(4): Excel Solution by np_rt)

I'm sorry np_rt. There was nothing incorrect about your Excel solution. I only proposed a different method that is debatedly easier or not.

When I said, "otherwise you have nothing", I was reffering to the IF statement that I typed. I think it went something like "IF(A1=E1,"Yes",""). If you follow the logic of this IF statement, it says if a1 = e1 then you have "Yes", otherwise you have "" which is the nil value. I was really saying "otherwise I have nothing" :)

 

Posted by Michael on 2004-11-30 01:38:13