more-arw search

Excel Lookup Worksheet

To view this Resource, use the form on the right

Here's simple worksheet in response to: Excel Formula to Calculate Year End Bonus, at:
https://www.proformative.com/questions/excel-formula-calculate-year-end-bonus

It uses MATCH functions to find the profit amount and the profit-percentage amount. Then it calculates the bonus based on the minimum of the two values returned.

Because MATCH's third argument is omitted, each MATCH formula uses an approximate search, returning the row-index number that is less than or equal to the value for which you search.

Charley

Fill out this form to become a member and get access to all resource, videos, and whitepapers on Proformative.
Clear the field above and enter the number as indicated
By filling out this form you will become a member of Proformative, and are subject to Proformative's User Agreement.