Wilhelm Sorban
07-20-2012, 11:40 PM
Hey!
I tried an IF Function, the problem is, I need to use too many functions, and it exceeds the limit.
So my question is, if I need X numbers of something, to make 1 numbers of something else, but X can constantly change, from a Drop-down list, and so can "something else", how do I do that?
For example:
a b c d e
1
2 1
3 2 1
4 3 2 1
5 4 3 2 1
I need 2*a to make 1*b, or I need 4*a, to make 1*c.
From the drop down list, I would choose "Make 1*d (d is chosen from list (which can be a,b,c,d,e)), using ?*a (a is chosen from list(which can be a,b,c,d,e))", since I want to know how many of a, or how many of b I need to make a c.
I hope I made this clear enough, if not, let me know and I'll explain further.
Thanks in advance!
I tried an IF Function, the problem is, I need to use too many functions, and it exceeds the limit.
So my question is, if I need X numbers of something, to make 1 numbers of something else, but X can constantly change, from a Drop-down list, and so can "something else", how do I do that?
For example:
a b c d e
1
2 1
3 2 1
4 3 2 1
5 4 3 2 1
I need 2*a to make 1*b, or I need 4*a, to make 1*c.
From the drop down list, I would choose "Make 1*d (d is chosen from list (which can be a,b,c,d,e)), using ?*a (a is chosen from list(which can be a,b,c,d,e))", since I want to know how many of a, or how many of b I need to make a c.
I hope I made this clear enough, if not, let me know and I'll explain further.
Thanks in advance!