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

Nested IF error
 

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

--
Don Guillett
SalesAid Software

"Ricardo Monteiro :^)" wrote in
message ...
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

Nested IF error
 

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(A15,A1<=10),"Hot",IF(A110 ,"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

Nested IF error
 

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

Nested IF error
 

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

Nested IF error
 

On Fri, 3 Feb 2006 06:33:10 -0800, "Ricardo Monteiro :^)"
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(a110,"very hot",if(a15, "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

Nested IF error
 

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 :^)"
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(a110,"very hot",if(a15, "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

Nested IF error
 

On Sun, 5 Feb 2006 05:51:26 -0800, "Ricardo Monteiro :^)"
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

Nested IF error
 

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

Nested IF error
 

On Sun, 5 Feb 2006 07:20:26 -0800, "Ricardo Monteiro :^)"
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

Nested IF error
 

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