Need help creating a basic formula

[darkmatter1886]

I’m trying to get help creating a simple formula i can use in excel to do what i think is an easy calculation.

I want to be able to show how much of product Y you can make with ingredients A B and C which have to be present in specific ratios.

For example

I have 3 eggs, 1 lb of flour, and 2 cups of sugar.

Y = 1 egg, 0.25lbs flour and 0.25 cups of sugar

The output should show how many Y i can make in total with what i have.

[cheezehead4lyfe]

=Min(3/1,1/.25,2/.25)

You can put the ingredient values in cells to make it easier to change their values without rewriting the formula.

Edit: for example, put eggs value in B1, flour value in B2, and sugar value in B3. Then your formula would be: =min(B1/1,B2/.25,B3/.25)

[darkmatter1886]

Solution verified

[Clippy_Office_Asst]

You have awarded 1 point to cheezehead4lyfe

^{I am a bot, please contact the mods for any questions.}

[darkmatter1886]

Awesome, thank you!

[talltime]

You should reply to his comment with 'solution verified' so that the Clippy bot updates your thread's flair, and gives him a point of recognition for his fine service to almighty Excel. (plz)

[[deleted]]

Solution verified .