I have a table of about 435 rows (and growing a bit). I have values in the column AJ and some are "0" which affect the percentile (even as nested...with the {})
This is my best guess, but as said, the percentile is still not correct, because of the "zeros":
=IFS(AJ4>=PERCENTILE(AJ:AJ;0,7);3;AJ4>PERCENTILE(AJ:AJ;0,4);2;AJ4=0;0;AJ4<PERCENTILE(AJ:AJ;0,4);1)
Any ideas?
This is my best guess, but as said, the percentile is still not correct, because of the "zeros":
=IFS(AJ4>=PERCENTILE(AJ:AJ;0,7);3;AJ4>PERCENTILE(AJ:AJ;0,4);2;AJ4=0;0;AJ4<PERCENTILE(AJ:AJ;0,4);1)
Any ideas?