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

Try

=IF(B75<CHAR(252),J75,"")



"Pat" wrote in message
...
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

Pat

Unless you have a UDF named NOTEQUAL you would be out of luck IMO.

Does this get you any closer?

=IF(AND(B5<CHAR(252),J5<0),J5,"")


Gord Dibben Excel MVP


On Tue, 11 Jan 2005 22:48:46 -0000, "Pat" wrote:

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