If functions

Hi Sarah
Sorry for late reply.
Multiple IF functions...

For example suppose you want to use multiple 'if' functions to tell you whether a temperature is hot if above 25C, warm if above 15C, or cold if 15C or below.

A B
Temp Hot/Warm/Cold Result
26 =IF(A2>25,"Hot",IF(A2>15,"Warm","Cold")) Hot
14 Cold
23 Warm

Create this example then copy the function from B2 to B3:B4 to see the result.

For more results, eg freezing if below 0C, replace "Cold" with IF(A2>0,"Cold","Freezing")