Nested IF error

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

try working from the top down
=if(a1>10,"very hot",if(a1>5, "hot","cold"))

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Ricardo Monteiro :^)" <RicardoMonteiro@discussions.microsoft.com> wrote in
message news:63666FEF-E549-4DC1-B373-6A3A227CF045@microsoft.com...
> 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

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"))

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"))
>

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

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
>

On Sun, 5 Feb 2006 05:51:26 -0800, "Ricardo Monteiro :^)"
<RicardoMonteiro@discussions.microsoft.com> wrote:

>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

Well, I'm glad you've got it working.

Although I don't really understand the relationship of Excel version and
inability to provide an error message. Maybe there's a language problem
impeding my understanding of this issue.
--ron

You don't have a condition if A1 = 5. For what you've asked for, here is
your equation

=IF(A1<5,"Cold",IF(AND(A1>5,A1<=10),"Hot",IF(A1>10,"Very Hot",NA())))

"Ricardo Monteiro :^)" wrote:

> 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