Number sequencing programming problem

**ScabbyDog** · 04-29-2009, 09:24 AM

This is basically what I'm trying to do in Excel.
I'm trying to find all the possible combinations of a number between 2795 and 5000 exclusive which can increase in increments of 5, and that is made up of 92 notes that include 5 euro notes, 10 euro notes, 20 euro notes, 50 euro notes and 100 euro notes.

Can anyone code this for me?
Thanks.

**zbor** · 04-29-2009, 09:31 AM

You can write numbers from 2795 to 5000 in an column and then:

=IF(MOD(A1;185)=0;A1;"")

Where A1 is first number and 185 is summ of notes (5+10+20+50+100). I assume you need only if you can use ALL of them.. Because if you can use ANY you would get all numbers.

Edit: sorry, wrong one.. you need to have 92 bank notes exactly? for example: 5+5+5+5+10+10....+100+100.. and get combinations for all numbers?

I didn't calculate it, but on first view I would say you can combine any of those numbers...

**ScabbyDog** · 04-29-2009, 09:47 AM

Originally Posted by zbor

You can write numbers from 2795 to 5000 in an column and then:

=IF(MOD(A1;185)=0;A1;"")

Where A1 is first number and 185 is summ of notes (5+10+20+50+100). I assume you need only if you can use ALL of them.. Because if you can use ANY you would get all numbers.

Edit: sorry, wrong one.. you need to have 92 bank notes exactly? for example: 5+5+5+5+10+10....+100+100.. and get combinations for all numbers?

I didn't calculate it, but on first view I would say you can combine any of those numbers...

yeah i need 92 bank notes exactly! and you dont have to use every note (5, 10, 20, 50, 100) and you can use any combination of notes.