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

Try something like:

Case (

Grade ≥ 4 ; 4.01 ;

Grade ≥ 3.85 ; 4 ;

Grade ≥ 3.7 ; 3.85 ;

Grade ≥ 3.5 ; 3.7 ;

Grade ≥ 3.3 ; 3.5 ;

Grade ≥ 3.15 ; 3.3 ;

Grade ≥ 3 ; 3.15 ;

Grade ≥ 2.85 ; 3 ;

Grade ≥ 2.7 ; 2.85 ;

Grade ≥ 2.5 ; 2.7 ;

Grade ≥ 2.3 ; 2.5 ;

Grade ≥ 2.15 ; 2.3 ;

Grade ≥ 2 ; 2.15 ;

Grade ≥ 1.7 ; 2 ;

Grade ≥ 1.35 ; 1.7 ;

Grade ≥ 1 ; 1.35 ;

Grade

)

Note:

I have taken into account your lower boundaries only. As LaRetta pointed out, you have a gap.I have also assumed that grades below 1 are unchanged.