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

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Ricardo Monteiro :^)" <RicardoMonteiro@discussions.microsoft.com> wrote in
message news:39E8449E-1482-401C-8E71-37CF78E13443@microsoft.com...
> 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(a1>10,"very hot",if(a1>5, "hot","cold"))
>