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

Find the house(s) at the 80th percentile of all sample houses with respect to appraised value. Find the house(s) at the 80th percentile of all sample houses with respect to selling price.

Solved by C. Q. in 28 mins

sir, how to find age calculator age on date formula

Solved by A. A. in 22 mins

I need a formula to find what the average transfer % is for the 0.25% percentile of a population using certain criteria.

Solved by S. S. in 18 mins

I need a formula that ranks the highest number in the 1st percentile and the lowest number at the 100th percentile.

Solved by T. D. in 25 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