IF function: ice alert
Build a simple weather alert: a logical test (temperature ≤ 3°C), then an IF function that displays a message — 4 guided steps, write the formula then fill it down.
Write the test in cell C2
1 / 4
Test: temperature ≤ 3 °C
=B2<=3
2 / 4
Fill the test down (column C)
=B15<=3
Write the IF function in cell D2
3 / 4
IF: "Ice alert" if < 3 °C [excellab id="demofonctionsi-q3"]
=IF(B2<=3,"Ice alert","")
4 / 4
Fill the IF down (column D)
=IF(B15<=3,"Ice alert","")
Your score is
Restart
