All about flooble | fun stuff | Get a free chatterbox | Free JavaScript | Avatars
 perplexus dot info

 Center Digits (Posted on 2004-11-28)
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'.)

 See The Solution Submitted by Brian Smith Rating: 2.2500 (4 votes)

Comments: ( Back to comment list | You must be logged in to post comments.)
 re(2): Excel Solution | Comment 5 of 15 |
(In reply to re: Excel Solution by Sandeep)

I did it with Excel too but did not post as others have posted. Here's how I did it:

Column A: Listed 3163 to 9999
Column B: Square of Column A
Column C: Used rounddown function to round down B/1000000
That gets the very first two digits (wx in this case)
Column D: Column B minus 1000000 times Column C
This gets rid of the first two digits
Column E: Round down column D divided by 100
This gets rid of the last two digits
Column F: Column A minus Column E
Column G: Copy Column F, Paste the values using paste special
This is important since you cannot look for the 0 with any
function if it's filled with a formula

Last Step: Use the find cell under Edit to find a cell with a value of 0.

 Posted by np_rt on 2004-11-28 18:35:05

 Search: Search body:
Forums (0)