Nested IF error

  • Thread starter Ricardo Monteiro :^)
  • Start date
R

Ricardo Monteiro :^)

If A1 is said:
10, the result is "Very hot".
Click to expand...

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
 
D

Don Guillett

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

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())))
 
R

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

Ron Rosenfeld

That's working, but I try to add more and it says it has too much.
Any help?

Thank you both.

"Don Guillett" escreveu:
Click to expand...

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
 
R

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

Ron Rosenfeld

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
Click to expand...

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
 
R

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

Ron Rosenfeld

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

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
 
R

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