The Royal Black Watch Forums

Public Discussion => General Discussion => Topic started by: MagiK_ on January 17, 2020, 06:10:19 AM

Title: Math and Excel help
Post by: MagiK_ on January 17, 2020, 06:10:19 AM
Hmm  cant figure out how to past a small image of the excel sheet  :(
Malcolm Reynolds
4 mins

Need some Math Help. Have a recipe with 5 ingredients,
ingredient #1 - 3 requires 2 units each, Ingredient 4 and 5 require 5 units each to make one serving.

What I need is a formula to use in excel that will tell me how many servings I can make with the materials on hand (quantites on hand are listed in cells D3 - 7) and the formula will be applied to E9
Ill be using the formula for other recipes as well.

my first recipe is for Bewitched Sugar Skulls.
MagiK  you can email me directly at immagikman at gmail dot com
Title: Re: Math and Excel help
Post by: MagiK_ on January 18, 2020, 01:25:08 AM
NM Lily pointed out my problem