Needing help /w Excel formula

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 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

See More: Needing help /w Excel formula

Report •

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:


Report •
Related Solutions

Ask Question