Logical problem

[JXBlack]

I have a worksheet where the col D is either the word "buy" or the word "sell"
I have written the formula:

=if(d4=buy,1,-1)

The answer comes up NAME when I expected either a 1 or a -1

What am I doing wrong


Thanks

[stanleydgromjr]

JXBlack,

Try:
=IF(D4="buy",1,-1)