Jonathan,
=IF(x0,1,0)
HTH,
Bernie
MS Excel MVP
"Jonathan" wrote in message
...
I am trying to define the function sign(x) in Excel. Sign (x) = 1 if x0,
sign(x)=0 if x<0 and sign(0)=0. I know that it is probably straightforward
to
do as an if statement, but I wondered if there is just an explicit
function
in Excel that would do it for me.
|