Thread
:
IF statement using number ranges
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Don Guillett
external usenet poster
Posts: 10,124
IF statement using number ranges
=if(a2=10,1,if(a2=15,2,"error"))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Quimera" wrote in message
news:yhlhm.41271$PH1.18314@edtnps82...
I need a nested IF formula that can assign a code to a range of numbers.
There are 5 ranges.
For example...If (A2=10 and <=14, "1", IF (A2=15 and
<=140,"2"),IF(......."5"),"Error"))
I don't know how to define the range.
Thank you for your always helpful help.
Rose
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett