View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pradip Jain Pradip Jain is offline
external usenet poster
 
Posts: 25
Default If Then Else Statement

Hi
I am using the following code:

If Distribution = 2 Then Param1 = Mean And Param2 = StDev Else Param1 =
UpperBound And Param2 = LowerBound

Variables Param1 and Param2 are not picking up any values. When i keep just
one variable then it is working. Thus the following code works:

If Distribution = 2 Then Param1 = Mean Else Param1 = UpperBound

Please help

Thanks, Pradip