If function

%3CLINGO-SUB%20id%3D%22lingo-sub-326331%22%20slang%3D%22en-US%22%3EIf%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326331%22%20slang%3D%22en-US%22%3EI%20am%20trying%20to%20use%20the%20if%20function%20to%20calculate%20mean%2C%20median%20and%20mode%20for%20distribution%20for%20each%20location%20and%20I%20am%20getting%20no%20where.%20I%20can%20calculate%20the%20average%20but%20nothing%20else!%20What%20am%20I%20doing%20wrong%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-326331%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EIf%20function%20help!%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326372%22%20slang%3D%22en-US%22%3ERe%3A%20If%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326372%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eif%20you%20want%20to%20calculate%20the%20median%2C%20where%20does%20the%20IF%20function%20come%20in%3F%20Can%20you%20step%20back%20and%20post%20some%20sample%20data%20that%20illustrates%20your%20scenario%2C%20then%20mock%20up%20the%20desired%20result%20and%20explain%20the%20rules%20that%20lead%20to%20that%20result%3F%20Don't%20assume%20that%20any%20function%20like%20IF%20needs%20to%20be%20in%20the%20solution.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBy%20the%20way%2C%20the%20median%20can%20be%20calculated%20with%20the%20MEDIAN()%20function.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
I am trying to use the if function to calculate mean, median and mode for distribution for each location and I am getting no where. I can calculate the average but nothing else! What am I doing wrong?
1 Reply

Hello,

 

if you want to calculate the median, where does the IF function come in? Can you step back and post some sample data that illustrates your scenario, then mock up the desired result and explain the rules that lead to that result? Don't assume that any function like IF needs to be in the solution. 

 

By the way, the median can be calculated with the MEDIAN() function.