AnsweredAssumed Answered

Help with calculation

Question asked by Sendnot on May 26, 2009
Latest reply on May 27, 2009 by Sendnot

Title

Help with calculation

Post

I've been trying to write a fairly simple calculation, except that it doesn't work as I'd expect. What I'm trying to do is to calculate a "mid-point" grade; that is, if an average grade is a 1.35, then the "mid-point" grade is a 1.70, a 1.70 becomes a 1.85, the 1.85 becomes a 2.00, etc... on up to 4.01.

 

Below is what I've written:

 

Case(Final Average_ALPHA ≥ 1.35 and Final Average_ALPHA ≤ 1.7;"1.70";Final Average_ALPHA ≥ 1.70 and Final Average_ALPHA ≤ 1.85 ;"1.85";Final Average_ALPHA ≥1.85 and Final Average_ALPHA ≤ 2;"2.00" ;Final Average_ALPHA ≥2.15 and Final Average_ALPHA ≤ 2.3;"2.30";Final Average_ALPHA ≥2.30 and Final Average_ALPHA ≤ 2.5;"2.50";Final Average_ALPHA ≥2.50 and Final Average_ALPHA ≤ 2.7;"2.70";Final Average_ALPHA ≥2.70 and Final Average_ALPHA ≤ 2.85;"2.85";Final Average_ALPHA ≥2.85 and Final Average_ALPHA ≤ 3;"3.00";Final Average_ALPHA ≥3.00 and Final Average_ALPHA ≤ 3.15;"3.15";Final Average_ALPHA ≥ 3.15 and Final Average_ALPHA  ≤  3.3;"3.30"; Final Average_ALPHA ≥ 3.3 and Final Average_ALPHA  ≤  3.5; "3.50"; Final Average_ALPHA  ≥ 3.5 and Final Average_ALPHA  ≤ 3.7; "3.70"; Final Average_ALPHA  ≥ 3.85 and Final Average_ALPHA  ≤ 3.98; "4.00"; Final Average_ALPHA  ≥ 3.99; "4.01")

 

From my point of view, it should work, but a 1.70 produces a 1.70 when I'd like to see 2.0 instead. Please help!

 

Thanks-:smileyindifferent: 

Outcomes