8 Ağu 2023 ... The formula for cell D3 is =MEDIAN(IF(AND(B2:B9="a",A2:A9=6),C2:C9)), which returns the incorrect Median for the list. 6, a, 1, 3. 6, f, 78. 6 ...
I'm having trouble creating a MEDIAN(IF(AND function in excel.
This summary was compiled by our editorial team from publicly available information for quick reading. For full details, refer to original reporting where available.
