Formula for Question 8, cell B18.

The formula calculates points based on the match result in cell A18. A win (W) gives 3 points, a draw (D) gives 1 point, and a loss (L) gives 0 points.

When the formula from B18 is copied to G23, the relative cell reference A18 will change to F23.

This formula calculates the total points scored by a team. Assuming the individual match points for a team are in the range B2 to B100.

The algorithm is converted into Pascal code, including reading two integers, calculating their difference, and printing the result.

Program rectAB;
Var A, B, Diff: integer;
Begin
  ReadLn(A);
  ReadLn(B);
  Diff := A - B;
  WriteLn(Diff);
End.

The algorithm is converted into C code, including reading two integers, calculating their difference, and printing the result.

#include <stdio.h>
int main () {
  int A, B, Diff;
  scanf("%d", &A);
  scanf("%d", &B);
  Diff = A - B;
  printf("%d\n", Diff);
  return 0;
}