Display char 252
 

I am trying to get the following formula return CHAR252 if I77 contains a
number greater than 0.

=IF(ISNUMBER(I77)*(I770),"",CHAR(252))

Thank you if you can help.
Pat

Hi Pat

syntax of an IF statement
=IF(Test,TRUE,False)

so
=IF(ISNUMBER(I77)*(I770),CHAR(252),"")

Should work for you
Cheers
JulieD


"Pat" wrote in message
...

I am trying to get the following formula return CHAR252 if I77 contains a
number greater than 0.

=IF(ISNUMBER(I77)*(I770),"",CHAR(252))

Thank you if you can help.
Pat

That works fine if I77 contains a number greater than 0, If not it returns
false, is that what you are trying to avoid?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pat" wrote in message
...

I am trying to get the following formula return CHAR252 if I77 contains a
number greater than 0.

=IF(ISNUMBER(I77)*(I770),"",CHAR(252))

Thank you if you can help.
Pat