Nested If - use lookup instead?

[hedgie]

I can't seem to find this in the archives.

I have a complicated Nested If statement that basically says the following:

=if(a1="Multiply", b1*d1,if(a1="divide", b1/e1, if(a1="add", b1+f1,b1),c1),0),0)

As the spreadsheet grows, the nesting is growing too. I would like to make a database table which would have the ability to add conditions.

Multiply column 2 * column 4
Divide Column 2 / column 5 etc...


thsi way I can use a simple vlookup and then have a formula applied. Is there a way of using Index and match to accomplish this?

 

[Oaktree]

Aladin:

Is EVAL part of an add-in?

 

[Aladin Akyurek]

Aladin:

Is EVAL part of an add-in?

Yes, part of the morefunc.xll add-in. There is also a UDF in VBA by Charles (FastExcel, that is) in some thread on this site you can use.