Thread: If formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Chris is offline
external usenet poster
 
Posts: 788
Default If formula

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,