 # Get instant live expert help on lower quartile calculator “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! I am trying to create a quartile if function based on any one of several conditions being bet and then a quartile and if function with two conditions being met.
Solved by C. Y. in 21 mins
I'm trying to use the quartile function and I am getting a #num error for the first quartile but not the 2nd or third. I tried the percentile, and the same thing happens
Solved by K. A. in 28 mins
I wish to calculate the mean of a dataset of 445 positive numbers, including zero, that excludes the outliers. The greatest value of Quartile1 is less than the Inter-Quartile Range (IQR) between Q1 and Q3. When I subtract 1.5 times IQR from Q1, the result is a negative number. There are no outliers in Q1. When I add 1.5 times the Inter-Quartile Range to Q3, the result identifies 21 outliers. If I use TRIMMEAN, an equal number of values from the lower and upper range of data points is excluded. But I want the 21 large positive numbers excluded. How can I do this, please?
Solved by S. E. in 15 mins