Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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")) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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")) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I get error with "ROWS" in the formula - nested formula question | Excel Worksheet Functions | |||
Nested IF AND OR function Inexplicable error | Excel Worksheet Functions | |||
Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) |