For more than 7 I suggest a lookup table. Look in help index for VLOOKUP

--
Don Guillett
SalesAid Software

"Ricardo Monteiro :^)" wrote in
message ...
That's working, but I try to add more and it says it has too much.
Any help?

Thank you both.

"Don Guillett" escreveu:

try working from the top down
=if(a110,"very hot",if(a15, "hot","cold"))