View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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.