| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If Then Else Statement
If Distribution = 2 Then Param1=Mean Param2=StDev Else Param1=Upperbound Param2=LowerBoound End If HTH "Pradip Jain" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If Then Else Statement
You are trying to execute two statements in one command - that is invalid
syntax for what you want to do, but is valid syntax for something completely different (which is why you don't get an error). You need If Distribution = 2 Then Param1 = Mean Param2 = StDev Else Param1 = UpperBound Param2 = LowerBound End if -- Regards, Tom Ogilvy "Pradip Jain" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Linear Mode
