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"))))
|