Here are some problems that our users have asked and received explanations on
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
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
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
sir, how to find age calculator age on date formula