MEDIAN Function

[soubasa]

Hello, I have a question about MEDIAN Function :
A1 = 1500 , B1 = 1000 , C1 = 2000
I need Formula for check A1 if between B1 & C1 "NOT >= or <=" then show "TRUE" , if not show "FALSE"
for that formula : =IF(A1=MEDIAN(B1:C1),"TRUE","FALSE") .... works fine shows "TRUE"
but look at this one :
A1 = 1.12812 , B1 = 1.12755 , C1 = 1.15487
if A1 is between B1 & C1 then show me "TRUE" if not show "FALSE"
so with above Formula : =IF(A1=MEDIAN(B1:C1),"TRUE","FALSE") shows "FALSE"
I don't understand that reason

I would be grateful if you could help

[joeu2004]

You need to include A1 in the MEDIAN parameters. The first example worked only by coincidence. I would write:

=MEDIAN(A1:C1)=A1

if you want to return logical values TRUE and FALSE, not strings.

Or more generally:

=MEDIAN(B1,A1,C1)=A1

I prefer the latter because it shows our intent more clearly, to wit: A1 is literally "between" B1 and C1.

It also does not presume that A1, B1 and C1 are in contiguous cells.

FYI, this use of MEDIAN works for its purpose ("between") only when there are exactly 3 values to consider. Thus, the value in A1 is literally greater than 50% and less than 50% of the remaining data (the definition of the median value), if it is indeed between the values in B1 and C1.

[soubasa]

=MEDIAN(B1,A1,C1)=A1 .... it works very well
Thank You very much