Question 8

Which one of the given formula can be applied to assign a grade based on the given total in a cell name F4?

a.

=if (F4>=90,'A',if (F4>=80,'B',if(F4>=70,'C',if(F4>=60,'D','F'))))

b.

None of the given if statements are correct

c.

=if (F4>=90,'A',if (F4>=80,'B',if(F4>=70,'C',if(F4>=60,'D','F'))

d.

=if (F4>=90;'A';if (F4>=80;'B';if(F4>=70;'C';if(F4>=60;'D';'F'))))