All Questions
1
question
6
votes
2
answers
9k
views
Range mapping in Excel
I have a column of data in Excel with numbers [0..100]. I need a new column, which maps these to a new set of values such that:
> 90 : 4
80-90 : 3
70-79 : 2
60-69 : 1
< 60 : 0
I attempted to do ...