Thread
:
If Statements
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
If Statements
One way.
=IF(C6250,2,IF(C6=150,1,IF(C6=20,0,IF(C6=-20,-1,-2))))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Shortstopper00" wrote in message
...
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett