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.