IF statement using number ranges
This works...
=IF(A25999,"4",IF(A21500,"3",IF(A2269,"3",IF(A2 10,"2","Error"))))
I had an Excel Function Reference book and the solution was included in
a sample of nested IF statements.
Thanks for all your help.
Rose
"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
|