Mid Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

If this post's twice I apoligize but I have not seen the original I posted.
I need to calculate the Mid Range of three numbers(I've implemented the
MaxofList/MinofList,which work great). I added the following line :
-- If varMax > Values(intLoop) Or varMax < Values(intLoop) Then
which works when the numbers are linear 14,15,16 but if they are not or are
more than 1 point different it goes to max 13,14,18.

What am I not doing?
Ldappa
 
Hello "Ldappa".

Ldappa said:
Hi,

If this post's twice I apoligize but I have not seen the original
I posted. I need to calculate the Mid Range of three numbers (I've
implemented the MaxofList/MinofList,which work great). I added the
following line :
-- If varMax > Values(intLoop) Or varMax < Values(intLoop) Then
which works when the numbers are linear 14,15,16 but if they are
not or are more than 1 point different it goes to max 13,14,18.

What am I not doing?
Ldappa
Click to expand...

The easiest way will be (MaxofList+MinofList)/2.
 
I'm not sure if this would work as I have three independent numbers to
evaluate not a combination of min + max, Example: score1 = 13 score2 = 14
score3 = 17
min = 13 max=17 mid would be 14.
 
I'm not sure that would work as i have three independent numbers I'm
evaluating, example: score1=13 score2=14 score3=17
min 13 max 17
****mid 14*****
 
Back
Top