Originally posted by sonhouse
15: In cell E5 type "=IF(B2<2100,32,IF(B2<2400,24,16))"
In this step, does that statement cover the 2100-2400 area? I see all three K's there but how does it cover all three conditions? Not following the logic. Thanks.
Oh, I think I see it, if <2100, it's 32, if its <2400 it's 24, all else is 16, right?
Also, in the last line, you have 3 (((, but of the old rating in A2 right next to it?, what about B1, input, what do you type there?
"=IF(B2<2100,32,IF(B2<2400,24,16))"
The way the logic in excel works is:
IF(condition, true, false)
Broken down, it will be this:
If B2<2100 then return 32 else it will apply this:
If B2<2400 then return 24 otherwise it will return 16.
Therefore:
B2 below 2100, return 32.
B2 above 2100 and below 2400, return 24.
B2 above and equal to 2400, return 16.
The last line had a smilie which replaced one of the close brackets.
You don't need the " for typing text in excel directly.
"Input" is just a title above where you put the inputs. "Old Rating", "Opponent's Rating" and "Result" is put in b2, b3 and b4 (either W, D or L) respectively.