#INCORRECT ARGUMENT SET

nracelis

Hi all. Can anyone help troubleshoot this formula? I'm getting an #incorrect argument set error. Thank you in advance!

=IF([October Hours Under/(-)Over]@row <= 5, "Green", IF([October Hours Under/(-)Over]@row <= 10, "Yellow"), "Red")

Brian_Richardson

The closing parenthesis is too early.

=IF([October Hours Under/(-)Over]@row <= 5, "Green", IF([October Hours Under/(-)Over]@row <= 10, "Yellow", "Red"))

Dieplam

Hi all. Can anyone help troubleshoot this formula? I'm getting an #incorrect argument set error. Thank you in advance!

=VLOOKUP([Part Number]@row, {Price010625.xls Range 1}, 4, false)

Brian_Richardson

Are there 4 columns in your cross sheet reference range?

Dieplam

There are 6 columns, my look up column is 4

IamRachal_

Hi @Brian_Richardson, thank you for helping us learn from you. Could you help with my current formula and including two more sheet references.

Current formula that's working:

=IF(ISBLANK([Ticket #]@row), "", IF(COUNTIF({326 ARCHIVE Ticket #}, [Ticket #]@row) > 0, "Archive Sheet", IF(COUNTIF([Ticket #]:[Ticket #], [Ticket #]@row) > 1, "Current Sheet", "")))

I need to add two more cell references to scan and "produce" results in this column and I'm getting the "Incorrect Argument Set" error.

Thank you for your help!

Brian_Richardson

Incorrect Argument Set means that you have extra or missing arguments inside the parenthesis for a given function. So if you have =IF(logic, true result) that's fine but if you have =IF(logic) then it'll return Incorrect Argument Set because you're missing a required piece of the function.

So to add two more cell references, you can next more IFs, but you have to be careful about where your parenthesis are as well as the final "false" argument at the very end - the bit that gets returned if none of the IF statements are true.

=IF( logic, true result, IF( logic, true result, IF( logic, true result, final false result)))

My guess is that you may have accidentally tacked on your next IF statement after the final false argument instead of replacing it with the IF.

So if it looks like

=IF( logic, true result, IF( logic, true result, IF( logic, true result, final false result,IF(logic,true result, false result))))

then it's going to fail with INCORRECT ARGUMENT SET, because in that second to last IF statement you actually have 4 arguments, not the 3 that are supported.

Hopefully that made sense? If you want to post the formula that's failing, I can pinpoint the issue.