View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
m2work m2work is offline
external usenet poster
 
Posts: 2
Default Case selection in Excel 2003

I am working on a form that can be used for 15 different branches.'

If I type branch "10", info for branch 10 will display.
If I type branch "20", info for branch 20 will display.

I can do nested "if" statements, but I can only do up to 7 nested
statements, not for 15.

Is there a way to accomplish this? Any help is greatly appreciated.

Thanks,
m2