Nested IF error

[Ricardo Monteiro :^)]

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

[Don Guillett]

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

[Barb Reinhardt]

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

[Ricardo Monteiro :^)]

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

[Don Guillett]

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

[Ron Rosenfeld]

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

[Ricardo Monteiro :^)]

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
>

[Ron Rosenfeld]

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

[Ricardo Monteiro :^)]

What I meant is that I can't give you the text of the error in English,
because I use the Portuguese version.

"Ron Rosenfeld" escreveu:

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

[Ron Rosenfeld]

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

>What I meant is that I can't give you the text of the error in English,
>because I use the Portuguese version.

I should have guessed that. <sound of hand slapping forehead>

My wife's maiden name is also Monteiro. She's from Terceira and we return
there frequently to visit family.

The only other Monteiro I know is an Indian physician from Goa. I met him in
New Hampshire.

Eu só falo um português pequeno, e não muito bem.
Mas posso fazer BEM em restaurantes e barras!

Best wishes,

--ron

[Ricardo Monteiro]

The world is really small. And as we say here "You can find a Portuguese
everywhere".
Monteiro is quite common, especially in Cape Verde.
I don't know the Açores, but we're planning to go there soon.
Cumprimentos Ã* sua mulher (can you read that?).
Regards

Ricardo

"Ron Rosenfeld" escreveu:

> On Sun, 5 Feb 2006 07:20:26 -0800, "Ricardo Monteiro :^)"
> <RicardoMonteiro@discussions.microsoft.com> wrote:
>
> >What I meant is that I can't give you the text of the error in English,
> >because I use the Portuguese version.
>
> I should have guessed that. <sound of hand slapping forehead>
>
> My wife's maiden name is also Monteiro. She's from Terceira and we return
> there frequently to visit family.
>
> The only other Monteiro I know is an Indian physician from Goa. I met him in
> New Hampshire.
>
> Eu só falo um português pequeno, e não muito bem.
> Mas posso fazer BEM em restaurantes e barras!
>
> Best wishes,
>
> --ron
>