Finding Median

[LiveOak]

This is fairly easy. The median is the middle number. Say your numbers are A, B, and C.

Median (calculation, number) =

Case(

(A = 0) + (B = 0) + (C = 0) > 1, "Error",

A = 0, (B + C)/2,

B = 0, (A + C)/2,

C = 0, (A + :/2,

A >= B and A<= C, A,

A <= B and A>= C, A,

B >= A and B<= C, B,

B <= A and B>= C, B,

C >= B and C<= A, C,

C <= B and C>= A, C,

"")

-bd

[pharbor]

Is there a simple way to find the median? The filemaker online resource has some formulas but I find them difficult to understand.

My project involves four fields, three being numbers entered by the user and the fourth a calculation field. The calculation field must check each field to look for a zero value, if there is a zero, then the average of the two fields is calculated - this I have working using "IF" functions. If three legitimate numbers are entered then how do I find the median? Can this be done with a plug-in? Or do I need to do a combination of formulas? Any help I can get would be greatly appreciated.

[pharbor]

Thanks for your help. It does look fairly easy, now that I see it in black and white and it works perfectly. Thanks again.

[LiveOak]

When I get stuck, I've always found it pretty helpful to have someone to bounce ideas off of.

-bd