Forum Discussion

AJ_Smith's avatar
AJ_Smith
Copper Contributor
Sep 04, 2019
Solved

using multiple IFs with result as calculation

Hi all, I am working on the following formula but keep getting a null result.   =IF(AND(raw_data!$B$2:$B$1698=$A18, raw_data!$BA$2:$BA$1698=B$17), MEDIAN(raw_data!$AY$2:$AY$1698), "")   The form...
excel
Formulas and Functions
  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Sep 04, 2019

    AJ_Smith 

    Did you try it like this?

     

    =MEDIAN(IF(raw_data!$B$2:$B$1698=$A18,IF( raw_data!$BA$2:$BA$1698=B$17,raw_data!$AY$2:$AY$1698)))

AJ_Smith's avatar
AJ_Smith
Copper Contributor
Sep 04, 2019

Subodh_Tiwari_sktneer Ok, I tried entering your formula into a different cell and it seems to work! I think the column where I was entering the formula became formatted strangely--if I tried to change one cell, I would get an error message saying "you can't change part of an array." Not sure how that happened, but starting fresh seemed to get rid of the troublesome formatting. 

 

Thank-you!

Resources