Enter a formula in cell F4 using the IF function is an essential skill for anyone working with spreadsheets. The IF function allows you to perform logical tests and return…