Solve for integer combinations that equal a given ratio

[rinkjames]

Hi

I've been fiddling with columns and excel goal seek but I can't figure this out. I'm trying to find a list of number combinations that meet these requirements:

1. x/y = 16/13
2. x and y are integers
3. x*y < 4 million

So 512/416 and 1920/1560 are examples but a list of these is what I want. Is this possible?

P.S. Oh and x and y must be positive.

[Jakobshavn]

In A1 enter 16
In B1 enter 13
In C1 enter:
=IF(A1*B1>=4000000,"STOP HERE","") and copy down

In A2 enter:
=A1*ROW() and copy down

In B2 enter:
=B1*ROW() and copy down

In A1 thru C6 we see:

16 13
32 26
96 78
384 312
1920 1560
11520 9360 STOP HERE

[rinkjames]

Thanks a million

OH wait a minute. I clicked "SOLVED" too soon. The above solution works but it doesn't give all integer combinations. Where's 512/416 for instance?

[martindwilson]

maybe like this

[rinkjames]

Yeah this looks more like what I'm looking for. Thanks very much!