Results 1 to 7 of 7

Complex calculation using if, and, median

Threaded View

  1. #5
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Complex calculation using if, and, median

    As an addendum to my earlier post, if the 'Inside' result is supposed to be double the 'Outside' result, then you might be missing some parentheses, as well. Try the following if the efforts above are slightly off:

    =IF(AND(F7<=48,F7>=10,G7>=10,G7<=48),F5/B8,F5/(B8*2))

    EDIT: Nevermind, having re-read it I see that the 'False' return should be the one that's double.
    Last edited by CAntosh; 08-17-2016 at 11:11 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 08-09-2016, 12:50 AM
  2. Excel formula debugging - Median calculation
    By gdaniels in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-10-2014, 08:42 PM
  3. Median Absolute Deviation (MAD) Calculation
    By Arand in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-08-2013, 04:07 PM
  4. Conditoinal median calculation for a series
    By mahershams in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-24-2012, 10:10 AM
  5. Median calculation across two columns
    By captainjazz in forum Excel General
    Replies: 2
    Last Post: 06-21-2011, 10:02 AM
  6. Help with calculation of median
    By sssss in forum Excel General
    Replies: 8
    Last Post: 03-26-2010, 09:43 AM
  7. How to automate the calculation of the median from a frq distribut
    By Alaska Hydro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2005, 09:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1