View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default how do I find prime factors of a number

<sheepish look I inputted the wrong number to be missing the '5'. After
rechecking, it turns out I was inputting 123456789 rather than 1234567890.

Of interest is that the prime factors for 123456789 are very similar. Just
eliminate the 2 and the 5.

Nice routine.





On Tue, 29 Nov 2005 13:06:44 -0500, "Dana DeLouis"
wrote:

1234567890
-- one of its prime factors is 5, but it is not returned by your
algorithm.


Hi Ron. If I input 1234567890, then the numbers I get for cells A1:A6 a
2,3,3,5,3607, 3803.

I show one `5`. These factors check with another program. What numbers did
you get?


--ron