Thanks for all the great answers. I appreciate it. You people are the best.

"PCLIVE" wrote:

=IF(C2=0,"NEUTRAL",IF(C20,"OVER","UNDER"))

Regards,
Paul

"XFILES" wrote in message
...
Hello,

Here's what I'm trying to do. I have a number in cell C2. If the number
is
0 I want cell D2 to display, NEUTRAL, if the number in cell C2 is 0 I
want
cell D2 to display OVER, and if the number in cell C2 is <0 I want cell
D2
to display UNDER. I hope that makes sense. Thanks for any help anyone
can
give.