Forum Discussion

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
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)))

Subodh_Tiwari_sktneer

Silver Contributor

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
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!
- Subodh_Tiwari_sktneer
  Silver Contributor
  Sep 04, 2019
  You're welcome AJ_Smith! Glad it worked as desired.
AJ_Smith
Copper Contributor
Sep 04, 2019
Subodh_Tiwari_sktneer Thanks for the response. I tried your suggestion but now get a #NUM! error.