Need Help With IF statement
 

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.

Need Help With IF statement
 

=IF(C2="","",IF(C20,"Over",IF(C2=0,"Neutral","Und er")))


--
Regards,

Peo Sjoblom


"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.

Need Help With IF statement
 

Nevermind. I figured it out.

"XFILES" wrote:

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.

Need Help With IF statement
 

=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.

Need Help With IF statement
 

in D2 enter
=if(C20,"Over",If(C2<0,"Under",Neutral"))

"XFILES" wrote:

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.

Need Help With IF statement
 

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.