Skip to main content

All Questions

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 ...
Justin R.'s user avatar
  • 225