7 Haz 2020 ... Enter the MEDIAN IF Nested Formula · Select cell E10. · Type the following formula in the cell: · Press and hold the Ctrl and Shift keys.