Dell UNKNOWN

ok, so im basicly trying to come up with a formula which takes information from lets say Cell A1 and Cell B1 and then Cell 4A will decide how much i can make with the listed amounts from the other 2 cells. for an example, lets say im trying to figure out how much spaghetti i can make and in order to find this out, i need at least 3 cans of sauce and 3 packets of noodles in order to make 1 serving of spaghetti.

Cell A1 would be the sauce

Cell B1 would be the noodles

Cell D1 would be the servingsso... if i had 3 in A1 and 2 in B1, then D1 would equal 1 because it would meet all the requirments only to make 1 serving

If i had 100 in A1 and still only 2 in B1, D1 would still only equal 1 due to the requirments and then vice versa if i was only to have 2 in A1 and 100 in B1 where D1 would equal only 1 due to the requirments.

now if A1 and B1 both had 100 placed in them, then D1 would equal 30

if A1 had only 1 and B1 had 3, then D1 would equal 0 because of the requirments

I was thinking the formula in D1 would use the "if" function but i dont know how to make the answer increase or decrease on the numbers placed in A1 and B1. all i could get was true or false and even making it show up as a number im clueless on. I could be and probably am wrong about which function to use.

Thank you for the help and any suggestions

while asking around, i was actually suggested using this for cell D1 which actually seems to be working: =INT(MIN(A1/3,B1/2))

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History