Which function, IFS or SWITCH, can handle the following situation:

I want to write a formula that will look at each student's average in the

class and return a corresponding letter grade from a selected table. So$,$

in the graphic below, the formula would compare the values in column I

to the values in column K$.$ If the Grade $($column I$)$ is greater than the

value in Scale $($column K$),$ then return the corresponding letter value

$($column L$).$

Neither IFS or SWITCH will work here.

Only IFS will work in this scenario.

Both IFS and SWITCH can be used efficiently with this scenario.

Only SWITCH will work in this scenario.