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,