View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

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