Maths Help

[pinkee]

Can anyone help me with the following please:

The sum of the digits of the square of 49 (2401) is the square root of 49.
It is the first number to have this property ignoring one.

Can anyone tell me what the 2nd, 3rd and 4th numbers are that also have this property?

[bobbinwales]

Its interesting (if you like patterns like me) that the seemed to be a pattern forming with digitsums of 22 then 25 then 28- but then it jump's to 36 and then theres no more.
Pretty tough for a quiz pinkee!

[Atheist]

Is there such a thing as a digitsum function in Excel?

[bobbinwales]

yes. Try this after changing cell numbers to match your first row

=SUMPRODUCT(1*MID(C1,ROW(INDIRECT("1:"&LEN(C1))),1))

[Atheist]

Bobb; you'd think MS could come up with a simple DIGITSUM() rather than the way you did it.
I had to use Mid to put digits in a row across columns, then use VALUE to sum the digits etc. A touch of conditional formatting brought up the answers in pale green.
I started with numbers 1,2,3.....in colA, their squares in colB.
Quite fun fiddling with Excel again.
Thanks for your posts.
pinkee; do you know Excel?

[THECORBYLOON]

A good few year ago, I designed a control sheet that took the contents from various cells and combined them in another cell (A).

I had a function that was based on the contents of A but it wasn't recognising them.

After much searching on the Internet, I found out I had to multiple the contents of A by zero and then it was fine.

Now, how on earth would someone be expected to know that?