Use the excel if function to determine when students are cold.

If the temperature is less than that given in the cold if less than cell then output the string cold. If greater than output the string warm. (note: do not hard code the cold if less than, use a reference)

Give the top cell the correct relative and absolute references so that the formula can be dragged to the bottom cell and will have the correct calculation.

IF(logical_test,[value_if_true],[value_if_false])

A) Formula in top cell:

=IF(

B) Output of top cell (value):

C) Formula in bottom cell after dragging the top cell down:

=IF(

D) Output of bottom cell (value):