formula derived from cells

[abanky]

I know i've done this before, but can't figure it out.

A1: is a data validation list: Sum, Max, Min
A2: is a number
A3: is a number

I want a4 to become a formula based upon what is dropped down in A1 so, Sum(A2,A3), or Max(A2,A3), or Min(A2,A3)

 

[Special-K99]

One way
excel - Turn a string formula into a "real" formula - Stack Overflow

 

[abanky]

wasn't sure if there was a way to do it with out adding that mod

 

[FormR]

If you have XL2010 or higher, here is one option:

=AGGREGATE(INDEX({9,4,5},MATCH(A1,{"Sum","Max","Min"},0)),4,A2:A3)