I am writing the exact formula which is shown in the video, in the lecture exercise sheet, but it's not working. Everytime i press enter, a dialogue box appears saying that there's a problem with this formula.

Hello, PLease try using a different formula argument separator. Instead of writing ; use , or vice versa. =IF(argument 1; argument 2; argument 3) or =IF(argument 1, argument 2, argument 3) Thanks!