Using "if" function to translate 100 scale into 4.0 scale
I'm using MS Excel 2003 in Windows XP. I teach at a university in which
final grades must be submitted (today!) and they are on a 4.0 scale. My
students were graded on a 100 point scale. I'd have my grades in Excel and
I'd like to use a function such that if the final grade falls between 95-100
the student gets a 4.0, between 90-94 a 3.7, etc. I know how to use the "if"
function, but that would only allow me for two possible outcomes, whereas, I
need to have a range of outcomes from .7 to 4.0. (The increments are 1.0,
1.3, 1.7, 2.0, etc.) Any suggestions as to how to do this?
Thanks very much,