View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ISAF Media Analysis[_2_] ISAF Media Analysis[_2_] is offline
external usenet poster
 
Posts: 21
Default Help with positive and negative numbers

Hello,

I need help with a formula. I need a formula that determines if something
is positive or negative or neitral. For example:

A B C

Criminal Activity +3 Positive
Voter Registration -8 Negative
Counter-Narcotics 0 Neutral

In short, I would need this formula to be able to decern between the
positive, negative and neutral numbers in column B and put it into words in
column C. So, any positive number would be indicated a "positive" in column
C, any negative number would be indicated as "negative" in column C and the
number 0 would always be indicated as "neutral" in column C.

Any help would be appreciated.