# 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: