Home › Practice questions › IFS › Question 4

Excel IFS Practice Question: Find the shipping charge by weight: up to 1 kg is 40, up to 5 kg is 90, up to…

By Rinkesh Shah, founder of Cellgrids.

The question

Find the shipping charge by weight: up to 1 kg is 40, up to 5 kg is 90, up to 10 kg is 150, above that 300. Put it in C2 to C5.

The data

	A	B	C
1	Parcel	Kg	Charge
2	P1	0.5	?
3	P2	4	?
4	P3	8	?
5	P4	12	?

The yellow cells are where your answer goes.

Show answer

Expected results:

C2 = 40
C3 = 90
C4 = 150
C5 = 300

How it works

Explanation: The weights are tested from the smallest limit upwards, so each parcel gets the first limit it fits under.
Syntax: =IFS(B2<=1,40,B2<=5,90,B2<=10,150,TRUE,300)
0.5 kg is 40. 4 kg is 90. 8 kg is 150. 12 kg is above 10, so 300.

Try it yourself in the live sheet

Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.

Try this question in the live sheet →

IFS syntax

=IFS(logical_test1, value1, [logical_test2, value2], ...)

Checks multiple conditions in order and returns the value for the first one that's true. IFS is used to build decision rules directly into a spreadsheet instead of manually judging each row. Full IFS guide.