Display char 252

P

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
 
J

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
 
B

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)
 
Top