EleanorSykes1989
New Member
- Joined
- Aug 7, 2017
- Messages
- 16
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?
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?