If A1 is <5, the result is "Cold"; if A1 is >5, the result is "Hot"; if A1 is
>10, the result is "Very hot".

I tried different formulas from the help forum, but it keeps saying there's
an error.
I'm using Excel 2003 SP 2.

Thanks in advance