Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

A +B=C

Copper Contributor


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.

1 Reply
IF the ratio of chemical A: chemical B is 3:2 then if the desired amount of Blue is entered in A1 then the formula for chemical A is =A1*3/5 and the formula for chemical B is =A1*2/5