Display char 252

[Pat]

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

=IF(ISNUMBER(I77)*(I77>0),"",CHAR(252))

Thank you if you can help.
Pat

 

[JulieD]

Hi Pat

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

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

Should work for you
Cheers
JulieD

 

[Bob Phillips]

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)