"Mixing Paints" ratio maths question (more detail inside)?

[Lalalaaa]

"Kyle buys pink paint from two other manufacturers:
Paint G is made up from red and white paint in the ratio 1:4
Paint H is made up from read and white paint in the ratio 1:5
What is the least number he would need of each type in order to produce pink paint containing red and white in the following ratios?

2:9
3:14
10:43"

I have already worked out you need 10 pots of G and 12 pots of H for the 2:9 ratio, but I am stuck on the other 2 ratios (3:14 and 10:43) it does say it would be helpful to use Excel to solve this problem, but I have know idea what I would do with Excel to solve it.

10 points to the best answer.

[Ask_me]

for 2:9 you require only 5 pots of G and 6 pots of H because they would have equivalent of 1+1= 2 pots of red and 4+5=9 pots of white.

for 3:14, you require 5 pots of G with 12 pots of H, giving you equivalent of 3 pots of red and 14 pots of white.

For 10:43, you require 35 pots of G and 18 pots of H giving you equivalent of 7+3=10 pots of red and 28+15=43 pots of white.

Why Willy is incorrect is because each pot does not contain the same quantity of red and one pot of each would not add up to 2 portions of Red and 9 portions of White.

[willy tell]

2:9 1off Each G&H
3:14 2off H, 1Off G
10:43 7 off G, 3off H