View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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.