Give us some examples of what you want to do. On a general level, I
would say that you could use a lookup table which returns a formula as
a string in conjunction with a User Defined Function which makes use
of Evaluate in VBA, but without details of what you want to do it is
difficult to advise further.

Pete

On Feb 20, 4:58 pm, Chris wrote:
Hi,

I want to create an if function but I want to use more than 7 conditions and
it won't allow me. If I look in help it suggests using the lookup function
but from what I can see you can't use formulas as the result. As an example
I want to say if cell A1 is x then use this formulas, if cell A1 is z use
this other formula. And I need to do that 15 times. There must be a better
way rather than using a formula that is a mile and a half long.
--
Cheers,