I have two different excel tabs One of them have a column in a table which has the formulae. The other tab has the data from where it pulls the relevant data based on which Tiers (there are 3 tiers in the formulae as of now, we are implementing the 4th tier in this formulae) and the logic it needs to pull from the calculation that we are using here is:
=IF(AM3="",0,(IFERROR(IF(AND(AM3>=(VLOOKUP(VALUE(CONCATENATE($K3,$B3)),WynD_Incentives!$G:$AS,13,0)),AM3<=(VLOOKUP(VALUE(CONCATENATE($K3,$B3)),WynD_Incentives!$G:$AS,14,0))),(VLOOKUP(VALUE(CONCATENATE($K3,$B3)),WynD_Incentives!$G:$AS,15,0)), IF(AND(AM3>=(VLOOKUP(VALUE(CONCATENATE($K3,$B3)),WynD_Incentives!$G:$AS,16,0)),AM3<=(VLOOKUP(VALUE(CONCATENATE($K3,$B3)),WynD_Incentives!$G:$AS,17,0))),(VLOOKUP(VALUE(CONCATENATE($K3,$B3)),WynD_Incentives!$G:$AS,18,0)), IF(AM3>=(VLOOKUP(VALUE(CONCATENATE($K3,$B3)),WynD_Incentives!$G:$AS,19,0)),(VLOOKUP(VALUE(CONCATENATE($K3,$B3)),WynD_Incentives!$G:$AS,22,0)),0))),0)))
But I am facing an issue when I try to input the fourth tier in this case. Now the first and second tier have an upper bound and lower bound with the payout in the third column for tier 1 and 2. Earlier Tier 3 only had the lower bound but as they implemented the 4th tier they also brought the upper bound for Tier 3 and for the Tier 4 they have a lower bound and payout column.
Now I am trying to frame the formulae including the 4th tier as per below. But I am getting the error as per the screenshot. If you can help.
As per I understand there is only an issue with the 'paranthesis' in the formulae due to which we have the error as the 'too many arguments for this function'
I really need help with the same.
Bookmarks