IFS: many conditions in order
Exercise 1 of 3
Grades: 90 or more is A, 75 or more is B, 50 or more is C, anything else is D. In C2, give Ana's grade.
About this lesson
IFS checks tests in order and returns the result of the first true one, without nesting IF inside IF.
In this lesson
- Grades: 90 or more is A, 75 or more is B, 50 or more is C, anything else is D. In
C2, give Ana's grade. - Now give Ben's grade in
C3. - Shipping costs 4 up to 1 kg, 7 up to 5 kg and 12 up to 20 kg. In
C2, work out the shipping for parcel P-01.
Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.
fx
Type in C2 and press Enter to check.