How do I use the If function to tell me if a cell has a negative
 

If you use the insert menu - function there is a help in the bottom left
corner of the selection box. The if statement is set up as follows

if( statement, if true , if false)

so it would be
if( A3 < 0, 1, 2) which would put a 1 in the cell if negative and put 2 in
the cell if 0 or positive.

"pcmurph" wrote:

I need to figure out how to use the If function to tell me if a cell has a
negative value in it. I have a column of numbers (positive and negative) and
I want to call out in the next column over with either true or 1 if the
number is a negative value. I know this should be simple, but I don't know
what the keystrokes are to denote that in the formula. Thanks!