# IF Statement with Multiple Conditions and Multiple True/False Results

1. ## IF Statement with Multiple Conditions and Multiple True/False Results

Here is a sample of my data. I am trying to place the indicated scenario in E133.
E125 Initial Score: 93.1
E126 Initial Decile Rating: 2.5 (This score is derived how E125 is answered.)
E131 Statistical P-Value: 0.489
E132 Statistical P-Value <0.050: No (This score is derived how E131 is answered.)
E133 Adjusting Rating: 2.5 (This is where I need an IF statement)

So if E126 is 2.5 or 3.0 and E132=No, then E133 stays the same meaning either 2.5 or 3.0 respectively.

If E126 is <2.5 or >3.0 and E132=No, then E133=E126+0.5.  Register To Reply

2. ## Re: IF Statement with Multiple Conditions and Multiple True/False Results

If E126 > 2.5 and < 3.0 ???? Or is it if any other value than 2.5 and 3.0

Possibly ...???

IF(E132="No",IF(OR(E126=2,5,E126=3),E126,E126+0.5),0)  Register To Reply

3. ## Re: IF Statement with Multiple Conditions and Multiple True/False Results

E126 = any other value other than 2.5 or 3.0  Register To Reply