Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Function
=If(N6=4.6,€ťAssertive",IF(N6<=4,"Not
Assertive",if(AND(N64.1,N6<=4.5,"Somewhat Assertive")))) In this example what I want it to do is if 1. the number that appears is greater than 4.6 it should put in Assertive 2. the number that appears is equal to or less than 4.0 should put in Not Assertive 3. the number that appears is greater than or equal to 4.1 and less than or equal to 4.5 should put in Somewhat assertive Please tell me what I am doing wrong!! Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Function
=IF(N6=4.6,"assertive",IF(N6<=4,"not assertive","somewhat assertive"))
"sgreene" wrote: =If(N6=4.6,€ťAssertive",IF(N6<=4,"Not Assertive",if(AND(N64.1,N6<=4.5,"Somewhat Assertive")))) In this example what I want it to do is if 1. the number that appears is greater than 4.6 it should put in Assertive 2. the number that appears is equal to or less than 4.0 should put in Not Assertive 3. the number that appears is greater than or equal to 4.1 and less than or equal to 4.5 should put in Somewhat assertive Please tell me what I am doing wrong!! Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Function
Hi
You don't need the last IF. =IF(N6=4.6,"Assertive",IF(N6<=4,"Not Assertive","Somewhat Assertive")) Regards, Per "sgreene" skrev i meddelelsen ... =If(N6=4.6,€ťAssertive",IF(N6<=4,"Not Assertive",if(AND(N64.1,N6<=4.5,"Somewhat Assertive")))) In this example what I want it to do is if 1. the number that appears is greater than 4.6 it should put in Assertive 2. the number that appears is equal to or less than 4.0 should put in Not Assertive 3. the number that appears is greater than or equal to 4.1 and less than or equal to 4.5 should put in Somewhat assertive Please tell me what I am doing wrong!! Thank you. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Function
Thank you for responding so quickly, but I need 3 functions because Somewhat
goes from 4.1 to 4.5 and Not assertive is equal to or less than 4.0...or am I all wet? thanks "porter444" wrote: =IF(N6=4.6,"assertive",IF(N6<=4,"not assertive","somewhat assertive")) "sgreene" wrote: =If(N6=4.6,€ťAssertive",IF(N6<=4,"Not Assertive",if(AND(N64.1,N6<=4.5,"Somewhat Assertive")))) In this example what I want it to do is if 1. the number that appears is greater than 4.6 it should put in Assertive 2. the number that appears is equal to or less than 4.0 should put in Not Assertive 3. the number that appears is greater than or equal to 4.1 and less than or equal to 4.5 should put in Somewhat assertive Please tell me what I am doing wrong!! Thank you. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Function
Hi,
Just in case you're interested about the reason your original formula didn't work: The AND part of the formula has lost its closing bracket, and the end of the formula has one too many. It should look like this: =If(N6=4.6,€ťAssertive",IF(N6<=4,"Not Assertive",if(AND(N64.1,N6<=4.5),"Somewhat Assertive"))) Regards - Dave. =If(N6=4.6,€ťAssertive",IF(N6<=4,"Not Assertive",if(AND(N64.1,N6<=4.5,"Somewhat Assertive")))) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Function
Hi Dave thanks for responding...I copied and pasted your formula, but it
doesn't work...I keep getting an error. Any other suggestions? Thanks again. "Dave" wrote: Hi, Just in case you're interested about the reason your original formula didn't work: The AND part of the formula has lost its closing bracket, and the end of the formula has one too many. It should look like this: =If(N6=4.6,€ťAssertive",IF(N6<=4,"Not Assertive",if(AND(N64.1,N6<=4.5),"Somewhat Assertive"))) Regards - Dave. =If(N6=4.6,€ťAssertive",IF(N6<=4,"Not Assertive",if(AND(N64.1,N6<=4.5,"Somewhat Assertive")))) |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Function
Hi
If the value isn't = 4.6 and the value isn't <= 4, the value has to be 4 and < 4.6. Regards, Per "sgreene" skrev i meddelelsen ... Thank you for responding so quickly, but I need 3 functions because Somewhat goes from 4.1 to 4.5 and Not assertive is equal to or less than 4.0...or am I all wet? thanks "porter444" wrote: =IF(N6=4.6,"assertive",IF(N6<=4,"not assertive","somewhat assertive")) "sgreene" wrote: =If(N6=4.6,€ťAssertive",IF(N6<=4,"Not Assertive",if(AND(N64.1,N6<=4.5,"Somewhat Assertive")))) In this example what I want it to do is if 1. the number that appears is greater than 4.6 it should put in Assertive 2. the number that appears is equal to or less than 4.0 should put in Not Assertive 3. the number that appears is greater than or equal to 4.1 and less than or equal to 4.5 should put in Somewhat assertive Please tell me what I am doing wrong!! Thank you. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Function
This didn't work...I have 3 sections...Assertive, Not Assertive and Somewhat
Assertive When I put your formula in the only thing that shows in the cell is the formula Thanks again. "porter444" wrote: =IF(N6=4.6,"assertive",IF(N6<=4,"not assertive","somewhat assertive")) "sgreene" wrote: =If(N6=4.6,€ťAssertive",IF(N6<=4,"Not Assertive",if(AND(N64.1,N6<=4.5,"Somewhat Assertive")))) In this example what I want it to do is if 1. the number that appears is greater than 4.6 it should put in Assertive 2. the number that appears is equal to or less than 4.0 should put in Not Assertive 3. the number that appears is greater than or equal to 4.1 and less than or equal to 4.5 should put in Somewhat assertive Please tell me what I am doing wrong!! Thank you. |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Function
The formula can go in any cell on the worksheet except N6 (maybe O6???).
sgreene wrote: This didn't work...I have 3 sections...Assertive, Not Assertive and Somewhat Assertive When I put your formula in the only thing that shows in the cell is the formula Thanks again. "porter444" wrote: =IF(N6=4.6,"assertive",IF(N6<=4,"not assertive","somewhat assertive")) "sgreene" wrote: =If(N6=4.6,€ťAssertive",IF(N6<=4,"Not Assertive",if(AND(N64.1,N6<=4.5,"Somewhat Assertive")))) In this example what I want it to do is if 1. the number that appears is greater than 4.6 it should put in Assertive 2. the number that appears is equal to or less than 4.0 should put in Not Assertive 3. the number that appears is greater than or equal to 4.1 and less than or equal to 4.5 should put in Somewhat assertive Please tell me what I am doing wrong!! Thank you. -- Dave Peterson |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Function
Hi,
I've tried the following formula, and it works on my XL2000. =IF(N6=4.6,"Assertive",IF(N6<=4,"Not Assertive",IF(AND(N64,N6<=4.5),"Somewhat Assertive"))) If you copy and paste, it comes with an invisible "endline" character inside the formula, kindly inserted by this newsgroup window, which messes up formula. Try typing it in by hand. By the way, I had to change the 4.1 value in the AND statement, to 4 Otherwise any value between 4.01 and 4.1 would return a "False". Regards - Dave. "sgreene" wrote: Hi Dave thanks for responding...I copied and pasted your formula, but it doesn't work...I keep getting an error. Any other suggestions? Thanks again. "Dave" wrote: Hi, Just in case you're interested about the reason your original formula didn't work: The AND part of the formula has lost its closing bracket, and the end of the formula has one too many. It should look like this: =If(N6=4.6,€ťAssertive",IF(N6<=4,"Not Assertive",if(AND(N64.1,N6<=4.5),"Somewhat Assertive"))) Regards - Dave. =If(N6=4.6,€ťAssertive",IF(N6<=4,"Not Assertive",if(AND(N64.1,N6<=4.5,"Somewhat Assertive")))) |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Function
Hi,
The <=4.5 inside the AND statement also needs to be changed to <4.6 Otherwise values between 4.5 and 4.59 will return "FALSE" Sorry, should've noticed that the first time. Dave. |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Function
But, as has already been pointed out by Per Jessen, you don't need to test
for <4.6 because you've previously tested for =4.6. (... just as you don't need to test for 4, because you had previously tested for <=4). Instead of =IF(N6=4.6,"Assertive",IF(N6<=4,"Not Assertive",IF(AND(N64,N6<4.6),"Somewhat Assertive"))) you merely need =IF(N6=4.6,"Assertive",IF(N6<=4,"Not Assertive","Somewhat Assertive")) -- David Biddulph "Dave" wrote in message ... Hi, The <=4.5 inside the AND statement also needs to be changed to <4.6 Otherwise values between 4.5 and 4.59 will return "FALSE" Sorry, should've noticed that the first time. Dave. |
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Function
Hi,
I know, but sometimes it's nice to know if your own formula could have worked, even if it isn't the most streamlined way to achieve the purpose. Dave. "David Biddulph" wrote: But, as has already been pointed out by Per Jessen, you don't need to test for <4.6 because you've previously tested for =4.6. (... just as you don't need to test for 4, because you had previously tested for <=4). Instead of =IF(N6=4.6,"Assertive",IF(N6<=4,"Not Assertive",IF(AND(N64,N6<4.6),"Somewhat Assertive"))) you merely need =IF(N6=4.6,"Assertive",IF(N6<=4,"Not Assertive","Somewhat Assertive")) -- David Biddulph "Dave" wrote in message ... Hi, The <=4.5 inside the AND statement also needs to be changed to <4.6 Otherwise values between 4.5 and 4.59 will return "FALSE" Sorry, should've noticed that the first time. Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with IRR function | Excel Worksheet Functions | |||
Function problem | Excel Discussion (Misc queries) | |||
Problem with IF function | Excel Worksheet Functions | |||
FV Function Problem | Excel Worksheet Functions | |||
IF function problem | Excel Worksheet Functions |