IF formula for a number range specification
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
|