Lenny Conundrum #116

XenaAndGabrielle · **Posts:** 1225 **Joined:** Wed Nov 24, 2004 3:41 pm

samniann wrote:

woot! Thanks to xenaandgab for the excel(lent) tip
Took me some time cos i had trouble getting the sum function to regconise the individual units to have numerical value.

Yeah, my function for summing the digits was *NOT* pretty ... but it worked.

Kalathalan · **Posts:** 496 **Joined:** Sun Nov 14, 2004 8:35 am

Here's a hint someone could give me - which of the statements is false?

XenaAndGabrielle · **Posts:** 1225 **Joined:** Wed Nov 24, 2004 3:41 pm

Kalathalan wrote:

Here's a hint someone could give me - which of the statements is false?

That would probably make it a little too easy.

samniann · **Posts:** 97 **Joined:** Mon Apr 11, 2005 7:01 am

Kalathalan wrote:

Here's a hint someone could give me - which of the statements is false?

Not supported by excel, the false statement is. - Yoda.

Yoda ask me to tell you that. He likes to give riddles too.

stampsyne · **Posted:** Fri May 13, 2005 10:09 am

Am I the only one who didn't use a program or spreadsheet? *poke poke* I got the answer by trying to do all three (I should read more carefully) and finding one that fit two but not all three. Psha. Not exactly easy or hard.

I liked the last one better. Give me puzzles!

Chakra_ · **Posted:** Fri May 13, 2005 11:45 am

I just mearly typed out a random number that adds up to 43. DId not bother about the square n cube part. Lol

Zenial · **Posted:** Fri May 13, 2005 12:49 pm

Chakra_ wrote:

I just mearly typed out a random number that adds up to 43. DId not bother about the square n cube part. Lol

Yeah that'll win you prizes! :lol:

Atjj · **Posts:** 749 **Joined:** Wed Aug 11, 2004 1:25 pm

all i have to say is that you LC people intimidate me.

:cry:

Chakra_ · **Posted:** Fri May 13, 2005 4:42 pm

Zenial wrote:

Chakra_ wrote:

I just mearly typed out a random number that adds up to 43. DId not bother about the square n cube part. Lol

Yeah that'll win you prizes! :lol:

I rock

Wind · **Posted:** Fri May 13, 2005 7:55 pm

I made it with a table of squares and cubes and a pencil. And a big stroke of luck, of course.

Jazzy · **Posts:** 22 **Joined:** Mon Sep 06, 2004 10:42 am

I've already entered, but does anyone know the Excel formula that'll add up all the digits in a cell?

Personally, I did it with a friend, a calculator, and luck.

bijonfifi · **Posted:** Sat May 14, 2005 10:48 pm

I did the computation and then double check with a friend

XenaAndGabrielle · **Posts:** 1225 **Joined:** Wed Nov 24, 2004 3:41 pm

Jazzy wrote:

I've already entered, but does anyone know the Excel formula that'll add up all the digits in a cell?

Personally, I did it with a friend, a calculator, and luck.

There isn't a real function in EXCEL that I know of ... my equation was 2 lines long that I used to add the digits.

Chakra_ · **Posted:** Sun May 15, 2005 1:59 am

XenaAndGabrielle wrote:

Jazzy wrote:

I've already entered, but does anyone know the Excel formula that'll add up all the digits in a cell?

Personally, I did it with a friend, a calculator, and luck.

There isn't a real function in EXCEL that I know of ... my equation was 2 lines long that I used to add the digits.

Lucky i used the RANDOM ANSWER JAVA machine. That spent me. 2seconds.

_B4U_ · **Posted:** Sun May 15, 2005 7:30 pm

samniann wrote:

Kalathalan wrote:

Here's a hint someone could give me - which of the statements is false?

Not supported by excel, the false statement is. - Yoda.

Yoda ask me to tell you that. He likes to give riddles too.

I hate to make it more confusing for those of you trying to figure it out yet, but the statement that samniann was referring to is supported by Excel. So... yeah. You can disregard samniann's post. =0\

Pink Poogle Toy Forum

Lenny Conundrum #116

Who is online