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