Separate Numbers into Digits^3

[Sam9530130]

I need to create a loop (1 To n) that separates numbers into (digits)^3.
Then, if the sum of the digits^3 = the original number it should print it.

Let's say the number 153.

1^3 + 5^3 + 3^3 = 1 + 125 + 27 = 153. So that number should be printed.

[rylo]

Hi

How about

Please Login or Register  to view this content.

rylo

[Marcol]

What are you trying to achieve?

I haven't done a mathematic proof, but it looks to me that there are only 4 numbers, excluding 0 and 1, that meet your condition.

153
370
371
407

This workbook is setup to test from 1 to 100,000

Select from the drop-down in A1 to check the results.

[Sam9530130]

Hi

How about

Please Login or Register  to view this content.

rylo

Yes this is good, thank you very much.