I have a table that has two columns of ranges I would like to INDEX and MATCH.
EXAMPLE: I need to index and match 48.95% (in cell I4) using the table where Column O is 45% and column P is 50% with the probability column at $R$4:$R$43.
How do I INDEX and MATCH a percentage like that to fall...
How can I create a formula for this Calculation in Excel
76% on first $1,250 of Salary + 54% of following $3,750 + 45% of the remaining to a max. Of 8000$ or 85% of Salary whichever is less.
I appreciate any solution for this.