Sorry for the delay. in the meantime your suggested formulas helped to solve
the problem. I'm afraid I can't quote the exact error that appeared before,
because I'm using an international version of MS Office.
Thanks again

"Ron Rosenfeld" escreveu:

> On Fri, 3 Feb 2006 06:33:10 -0800, "Ricardo Monteiro :^)"
> <RicardoMonteiro@discussions.microsoft.com> wrote:
>
> >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"))
>
> Without more detail, it's hard to say.
>
> I've not seen an error message that says "too much". Is that the full text of
> the error message?
>
> There is a limit of seven nested functions.
> --ron
>