View Single Post
  #1   Report Post  
Pat
 
Posts: n/a
Default Notequal(Char(252) Help!

What is wrong with the following formula:

=IF((B75), NOTEQUAL(CHAR(252),(J75)*(J75<0)),"")
returns
#VALUE!

If B75 does not contain the character 252 return the value in J75

Thanks
Pat