Error with Median formula

[EleanorSykes1989]

Hi all,

I have a formula that pull back the median from a list of values:

=MEDIAN(IF('Median Gender Pay Gap'!N:N='Median Analysis'!G$4,'Median Gender Pay Gap'!AI:AI))

In order for to work I need to add the brackets back in: (like below)


{=MEDIAN(IF('Median Gender Pay Gap'!N:N='Median Analysis'!G$4,'Median Gender Pay Gap'!AI:AI))}

I think I need to highlight the formula and click one of the F buttons, but not sure which one? Can anyone help plz?

 

[AlanY]

to input the formula without the {}, and instead of enter, press Control-shift-enter together

the {} should added automatically if done right

 

[steve the fish]

You dont type those {} brackets in. Paste the formula into the cell then press CTRL-SHIFT then ENTER.