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.