MEDIAN IF

[Ellie_86]

I seem to be having a terrible 'Friday' moment.


=MEDIAN(IF('RTW Same Employer'!N114:N147,"<=24",'RTW Same Employer'!N114:N147))


Using it as a stanard formula and it comes up with #VALUE


Using it as an array formula and it comes up with #NUM


Any assistance would be grately appreciated and improve my friday immensley.


Thank you!

 

[NARAYANK991]

Hi ,


I am not very sure , but the basic construct of the formula appears to be wrong ; can you check out the following link ?


http://www.bettersolutions.com/excel/EIK284/LN622911811.htm


Narayan

 

[Hui]

I think it should be:

=MEDIAN(IF('RTW Same Employer'!N114:N147<=24,'RTW Same Employer'!N114:N147))

 

[Ellie_86]

Hui, can i buy you a beer or 250 of them??


Excel ninja is correct!!!!!!!!

 

[SirJB7]

Hi, Ellie_86!

Sorry for arriving at dessert time, but if no one accepts your offer... here I am!



Regards!

PS: I actually wouldn't care if 250 or more

 

[Hui]

Ellie_86


Next time you are in Perth, Western Australia I will take you up on that ! !