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.
Bookmarks