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
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" <[email protected]> wrote in message
news:%23d1Bw9C%[email protected]...
> 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" <[email protected]> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks