Percentile ifs in tables returning same value

[Doblez]

Hey,
I am trying to calculate a percentile of salleries in a table if they've worked between 24 and 60

MonthsWorked	Sallery
22	12124
23	12462
24	12521
24	12523
28	125232
60	13542
62	13800

What I've done so far which actually works:
25% Percentile sallery Monthsworked <24
Formula 1

{=PERCENTILE.EXC(IF(Table1[MonthsWorked]<"24";Table1[Sallery]);0,25)}

- Works as intended

Average if 24<MonthsWorked<24
Formula 2

AVERAGEIFS(Table1[Sallery];Table1[MonthsWorked];">24";Table1[MonthsWorked];"<60")

- Works as inteded

What I can't get to work:
Formula 3

{=PERCENTILE.EXC(IFS(Table1[MonthsWorked]<E$32;Table1[Sallery];Table1[MonthsWorked]>D$32;Table1[Sallery]);0,25)}

Returns the same as formula 1 even though it shouldn't.

I also tried this
Formula 4

{=PERCENTILE.EXC(IF(AND(Table1[MonthsWorked]>D$32;Table1[MonthsWorked]<E$32);Table1[Sallery]);0,25)}

Returns a num error

Do you have any clue as to how I would fix it or what's wrong? I am running them as array formulas with ctrl+shift+enter. (My tries are based off of this.
Ideally I'd like the 0.25, 0.5 and 0.75 percentile of the following:
MonthsWorked<24
24<MonthsWorked<60
60<MonthsWorked<120
Monthsworked>120


I have attached the original dataset for good measure.
In advance thanks for your help!

 

[Domenic]

In your first formula, since you're searching for a number and not text, you'll need to remove the quotes around the number 24. So your formula should be as follows...

=PERCENTILE.EXC(IF(Table1[MonthsWorked]<24;Table1[Sallery]);0,25)

...confirmed with CONTROL+SHIFT+ENTER. Now, based on the criteria, the formula should return the error value #NUM!.

Hope this helps!

 

[Domenic]

For your fourth formula, which includes multiple criteria, try...

=PERCENTILE.EXC(IF(Table1[MonthsWorked]>D$32;IF(Table1[MonthsWorked]<E$32;Table1[Sallery]));0,25)

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!