# Needing help /w Excel formula

Dell UNKNOWN
February 9, 2009 at 23:32:07
Specs: Windows XP, intell
 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 sauceCell B1 would be the noodlesCell 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 servingIf 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 30if A1 had only 1 and B1 had 3, then D1 would equal 0 because of the requirmentsI 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

See More: Needing help /w Excel formula

#1
February 10, 2009 at 00:12:31
 while asking around, i was actually suggested using this for cell D1 which actually seems to be working:=INT(MIN(A1/3,B1/2))

Report •
Related Solutions