Excel formula question

E

Efi

Hello,

Can you give me the formula in which I can count all the times ( in the range between 78000 and 90000) in which I receive numbers that can be read from left to right and from right to left and will look the same. ( like 87078 or 82028).

Please mail it to : [email protected] A.S.A.P

Thanks, Efi.

W

Wesley Crucius

I have to ask why?

A

Alex Pavloff

1) This is the wrong list to ask Excel questions on
2) This list isn't here to do your homework for your Excel class
3) If you can't take the time to read the list, I can't take the time to respond to your question
4) This list isn't here to respond to you A.S.A.P.

J

Jiri Baum

Alex Pavloff:
> 1) This is the wrong list to ask Excel questions on
> 2) This list isn't here to do your homework for your Excel class
> 3) If you can't take the time to read the list, I can't take the time to
> respond to your question
> 4) This list isn't here to respond to you A.S.A.P.

5) It's silly to use Excel (or any spreadsheet) to answer that question.

There are 10 such numbers beginning 78, 10 beginning 79 and 100 beginning 8
for a total of 120.

Moral: always look for the *appropriate* technological solution.

Jiri
--
Jiri Baum <[email protected]>
http://www.csse.monash.edu.au/~jiribvisit the MAT LinuxPLC project at http://mat.sf.net

R

RufusVS

You cheated!

You took a moment to think about the question!

(for those who missed the original post, the OP wanted an excel formula to return all the palindromic (reads the same forward and backward) numbers from 78000 to 90000)

B

Burda, Jason M.

I don't know how many responses you have received on this as I've been on
vacation. But, if you get an answer that involves solution without writing
VB code. I'd like to know.

Thanks

Jason

PhilCorso

Jiri,

But, did use Excel?

BTW, there is a legitimate quest to determine if all numbers in base 10
can become palindromes. The procedure is simple enough...

1) Pick a number.

2) Reverse the digit order and add it to the original.

3) Repeat with the number obtained in 2)

4) Keep repeating (if required) until the search results in a
palindrome.

Note: This process must have no carries, therefore each pair mut add to
9 or less.

Except for the nmber 196, all numbers up to 10,000 will become
plalindromic in relatively short time. However, the quest for a
plaindrome resulting from the number 196 has, thus far, eluded solution,
even though a number with 1,000,000 digits was reached.

Any takers? Assumng you're not too busy!

Regards,
Phil Corso, PE
(Boca Raton, FL)

H

Hellstern, Manny

Jiri:

I'm coming in late on this conversation, but has anyone suggested converting
the number to a string, create a variable that is the string "spelled" backwards and if the two are equal you have a palindrome.

Manny J. Hellstern
System Analyst
Mustang Engineering
Houston, TX 77077
(713) 215-8380
[email protected]

R

RufusVS

Here, have a formula:

palindromecount = (89-78+1)*10

J

Johan Bengtsson

This is the same as asking:
The answer is 42, what is the question?

Some of you recognise both the number and the idea, those of you
not recognising it please ignore this post...

/Johan Bengtsson

----------------------------------------
P&L, Innovation in training
Box 252, S-281 23 H{ssleholm SWEDEN
Tel: +46 451 49 460, Fax: +46 451 89 833
E-mail: [email protected]
Internet: http://www.pol.se/
----------------------------------------