Complicate Excel question?

[Wilhelm Sorban]

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!

[Admin]

Hi Wilhelm Sorban,

Welcome to ExcelFox !!!

Could you post a sample workbook along with the expected result ?

[Wilhelm Sorban]

Hey,

Thanks for replying!

So I have this workbook, and I want to create a calculator, using the variables in the "Work" sheet, and using the data from "Temp" sheet.

This site has the calculator I want to make, but it's in Java.
Diablo 3 Gem Calculator

Maybe if you take a look, it will explain better what I need.