 # Get instant live expert help on median formula excel “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

Hi, my name is Henry. I am working with the excel to analyse my data for psychological experiment. I have to code 4 condition. 0=both masculinity score and femininity score lower than median 1=masculinity score over median but feminity score lower than median, and it is male 2= masculinity score lower than median but femininity score over median, and it is female 3=both score over median I tried to make the "nested IF function" but it said error after I made this formula: =IF((AX>=2.727272,AY>=3.117646),"3", IF((AU=1,AX>=2.727272,AY<3.117647),"1", IF((AU=2,AX<2.727272,AY>=3.117647),"2","0"))) I dont get why it is wrong, thanks!
Solved by C. S. in 25 mins
I am trying out a formula I saw in google but its not working in my excel and producing an error. Can you please help me? =(NETWORKDAYS(StartDT,EndDT)-1)*(StopTime-StartTime)+IF(NETWORKDAYS(EndDT,EndDT),MEDIAN(MOD(EndDT,1),StopTime,StartTime),StopTime)-MEDIAN(NETWORKDAYS(StartDT,StartDT)*MOD(StartDT,1),StopTime,StartTime)
Solved by T. U. in 29 mins
I'm looking for a formula that will help me find anomalies in my Median column if the calculated value is 35% above the median then consider it as an anomaly
Solved by M. Q. in 19 mins
Is there a formula to find a mean or median of the same column in multiple (200) sheets?
Solved by S. Q. in 27 mins
I need a formula to return the median value of a range, after deducting the two lowest values
Solved by Z. E. in 22 mins