View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sweder sweder is offline
external usenet poster
 
Posts: 1
Default is there a "switch p, case 1 2 3 ...." flow control in Excel?

I want to execute one out of 5 formulas depending on whether a switch
variable takes the value 1, 2, 3, 4 or 5. Most programming languages have a
"switch p, case 1 F1, 2 F2, etcetera construct. Does that also exist in
Excel? I am using office 2003.