Let's imagine I have two sets of things:

Water bottles
Coke bottles

And in my excel I put my ratio of water bottles to coke bottles as lets say 2:3.

Now lets say in the water bottles say I enter 50. I want excel to automatically calculate how many coke bottles I will have based on my ratio 2:3.

If anybody can help with this? Perhaps provide an example worksheet.

Thanks