Error with Median formula

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?
 

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
3,970
Office Version
365, 2019, 2016
Platform
Windows
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

Well-known Member
Joined
Oct 20, 2009
Messages
7,793
Office Version
365
Platform
Windows
You dont type those {} brackets in. Paste the formula into the cell then press CTRL-SHIFT then ENTER.
 

Forum statistics

Threads
1,082,570
Messages
5,366,364
Members
400,886
Latest member
Fchel

Some videos you may like

This Week's Hot Topics

Top