Cell reference in MAXIFS() Function

Post Reply
Mennochio
Posts: 14
Joined: Tue May 26, 2020 6:20 pm

Cell reference in MAXIFS() Function

Post by 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
Posts: 14
Joined: Tue May 26, 2020 6:20 pm

Re: Cell reference in MAXIFS() Function

Post by Mennochio »

I suspect the answer is that the Criterion can't use a cell reference. Correct?
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 2935
Joined: Wed Mar 11, 2020 5:31 pm

Re: Cell reference in MAXIFS() Function

Post by 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
Post Reply

Return to “PlanMaker 2021 for Windows”