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
|