View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sgreene sgreene is offline
external usenet poster
 
Posts: 11
Default 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"))))