Assign shipping methods with IFS
IntermediateWhen you need to test multiple conditions and return different results, the IFS function is cleaner and easier to read than nested IF statements.
The IFS function checks conditions in order and returns the value for the first condition that is TRUE:
=IFS(condition1, value1, condition2, value2, ...)
For example: =IFS(A1<10, "Small", A1<50, "Medium", A1>=50, "Large")
This returns "Small" if A1 is less than 10, "Medium" if less than 50, or "Large" otherwise.
Important: IFS evaluates conditions from left to right and stops at the first TRUE condition. Order matters. If you check smaller thresholds first, you will get correct results.
Your task
A warehouse needs to assign shipping methods based on package weight. The shipping rules are shown in columns E and F:
- Up to 1 lb: Letter
- Up to 5 lbs: Standard
- Up to 20 lbs: Ground
- Up to 50 lbs: Freight
- Over 50 lbs: Heavy freight
In column C, use the IFS function to assign the correct shipping method for each package based on the weight in column B. Fill the formula down for all 8 packages.
Need some help?
Hint 1
The IFS function takes pairs of arguments: a condition to test, then the value to return if that condition is TRUE.
Hint 2
Check conditions from smallest to largest. Start with B2<=1 for Letter, then B2<=5 for Standard, and so on.
Hint 3
Your formula should have 5 condition-value pairs. The last condition can be B2>50 for "Heavy freight".
Assign shipping methods with IFS
IntermediateWhen you need to test multiple conditions and return different results, the IFS function is cleaner and easier to read than nested IF statements.
The IFS function checks conditions in order and returns the value for the first condition that is TRUE:
=IFS(condition1, value1, condition2, value2, ...)
For example: =IFS(A1<10, "Small", A1<50, "Medium", A1>=50, "Large")
This returns "Small" if A1 is less than 10, "Medium" if less than 50, or "Large" otherwise.
Important: IFS evaluates conditions from left to right and stops at the first TRUE condition. Order matters. If you check smaller thresholds first, you will get correct results.
Your task
A warehouse needs to assign shipping methods based on package weight. The shipping rules are shown in columns E and F:
- Up to 1 lb: Letter
- Up to 5 lbs: Standard
- Up to 20 lbs: Ground
- Up to 50 lbs: Freight
- Over 50 lbs: Heavy freight
In column C, use the IFS function to assign the correct shipping method for each package based on the weight in column B. Fill the formula down for all 8 packages.
Need some help?
Hint 1
The IFS function takes pairs of arguments: a condition to test, then the value to return if that condition is TRUE.
Hint 2
Check conditions from smallest to largest. Start with B2<=1 for Letter, then B2<=5 for Standard, and so on.
Hint 3
Your formula should have 5 condition-value pairs. The last condition can be B2>50 for "Heavy freight".