Hi



I winder if this kind of calculation is possible. Let say I have a number like 33525, I want to divide this by a number of other numbers and end up with 0, other numbers may be something like 375, 500, 750, 2000 etc and you can use any combination of them to get to 0.

For example if I had a start figure of 5000 I could use 2 x 2000 and 2 x 500 and it would leave 0 at the end.

(I am not sure if I have explained this properly, apologies if not)

Thanks

S

It is alas impossible to end up with zero when dividing a number by other numbers.
You can get very close to 0, but it will take an infinity of divisors to get to 0.
OTH if you want to end up with 1, I suggest you search the Net for " factoring numbers", or " splitting a number in prime factors". VBA will be needed anyway

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks for the help.