I am trying to create a formula table. For example,
If We need 500 gallons of Blue.
Chemical A it takes 300 gallons and chemical B take 200 gallons to make 500 gallons Blue. How do we tell the spreadsheet we need 500 gallons of Blue and the spreadsheet tells us how much of Chemical A and how much of Chemical B.