View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jean Jean is offline
external usenet poster
 
Posts: 78
Default More than 7 IF? any substitute?

Hey!
looks like excel 2003 limits nested IF for like 10, and i need to use
IF(IF(.....) 15 times. Do you guys know what it could be a substitute, excel
says use Lookup but my data is in a drop down list build by Validation Data,

any help is really welcomed!

Thanks a lot!!