The column immediately adjacent will be used to add a bonus for all runners who improved their performance. This uses the =IF() function.
The basic rule is: "A runner who is faster in the third round than in the first round will receive a bonus of five seconds that is deducted from the total race time.”
Inside of the =IF() parentheses, the structure is always as follows (If; Then; Else).
If everything is now added up, the information inside the parentheses can be translated as follows:
- "If lap 1 is greater than lap 3 ;
- Then 5 seconds will be deducted from the total result ;
- Else the normal total result will be shown."
The sum function in column "E" states the total race time, so 5 units will be deducted from "E", or: "E-5".
The values for laps 1 and 3 are shown in columns "B" and "C". Again taking John Doe as an example, the =IF() function would look like this: =IF(B2>D2;E2-5;E2)
This function then populates the following cells as well.