View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Phil Hageman[_3_] Phil Hageman[_3_] is offline
external usenet poster
 
Posts: 160
Default ComboBox Population of Cell Range

These two formulas work. Can they be combined, or should code doing the same thing be used in a module

=IF(((Variables!C11="T1")+(Variables!C11="T2")),Va riables!D8,"Select Strategy"

=IF(((Variables!C11="R1")+(Variables!C11="R2")+(Va riables!C11="R3")+(Variables!C11="R4")),Variables! D9,"Select Strategy")