enter 1 if cell is negative number, zero if positive

[guamlenahans]

Hi,

I have a number in Cell G1. This number will be either negative or positive. Im trying to write a formual in cell I1 that will display a 1 if G1 is negative and a 0 if G1 is positive. Thanks for the help!

Rob

 

[Finalfight40]

how about:

=IF(G1<0, 1, 0)

although are you counting 0 as positive or negative?

 

[Gerald Higgins]

Or slightly simpler . . .

=--(G1<0)

 

[guamlenahans]

Perfect, thanks