Thread: If Statements
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shortstopper00 Shortstopper00 is offline
external usenet poster
 
Posts: 11
Default If Statements

I need a statement that will allow me to get answer based on a certain criteria
I have a column of answers ranging from -400 to 400. Now I need a certain
range of numbers to be changed into one value.
< -150 has to come as a -2

150 to -20 has to come up at a -1

20 - 150 has to come up as a 0

150 - 250 has to come up as a1

250 has to come up as a 2


I want the single integars in a column right beside the larger number.