|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 servings
so... 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