“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

please help i need to find median and quartile measures from this set of data

Solved by Z. Y. in 27 mins

I have created a formula with true and false however would like it to be $0 if the cells are blank.
=IF(AND(OR('BT Calculator'!C4="Super/Pension",'BT Calculator'!C4="IDPS"),'BT Calculator'!D4-'BT Calculator'!E4=0),180,540)

Solved by O. E. in 12 mins