Forum Discussion
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...
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)))
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 Thanks for the response. I tried your suggestion but now get a #NUM! error.