Cell reference in MAXIFS() Function

[Mennochio]

In the "Income" col of the IRS tax table, "Table1", I want to find the largest value that doesn't exceed the value in cell G17.

This works: =MAXIFS(Table1[Income],Table1[Income],"<147492")

This doesn't: =MAXIFS(Table1[Income],Table1[Income],"<G17")

Cell G17 is outside the table on the same sheet and contains the value 147492. When I try to use the cell reference in the criterion it just gives me the first cell in the Income col: 0.
Is there a way to use a cell reference in the criterion, or does it require a fixed value?

Thx.

[Mennochio]

I suspect the answer is that the Criterion can't use a cell reference. Correct?

[SuperTech]

Thanks for reporting this problem. Please share the associated file of PlanMaker 2021 in which you are getting this problem so that we can do further investigation for resolution.

If you want to send it to us privately, please e-mail us at the forum[at]softmaker.de

Please also include the forum URL of this topic so that we can trace your e-mail.
viewtopic.php?f=383&t=21994