LiveOak Posted July 28, 2001 Posted July 28, 2001 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

Newbies pharbor Posted July 29, 2001 Newbies Posted July 29, 2001 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.

Newbies pharbor Posted July 31, 2001 Newbies Posted July 31, 2001 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 Posted July 31, 2001 Author Posted July 31, 2001 When I get stuck, I've always found it pretty helpful to have someone to bounce ideas off of. -bd

## Recommended Posts

This topic is

8506 days old. Please don't post here. Open a new topic instead.## Create an account or sign in to comment

You need to be a member in order to leave a comment

## Create an account

Sign up for a new account in our community. It's easy!

Register a new account## Sign in

Already have an account? Sign in here.

Sign In Now