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.
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)
Thank you sir.