wiggins2402
New Member
- Joined
- Aug 5, 2016
- Messages
- 9
- Office Version
- 2016
- Platform
- Windows
I am trying to find a simple solution without having to do multiple IF AND statements. I have a table with a column of dollar values and a row of percentages. If the dollar amount I am looking for falls in a specific range and the percentage falls in a specific range I want to bring back the value that intersects the two to use in another calculation. In the table below I want to find where a customer's purchases fall and the row percentage represents the growth value. if they met minimum purchases and achieved growth targets they they would qualify for a rebate where the two intersect.
So I want to find the purchase value of 500,000 and 23% growth. The result should be 2.25%. Does anyone have an alternative to IF AND Statements?
So I want to find the purchase value of 500,000 and 23% growth. The result should be 2.25%. Does anyone have an alternative to IF AND Statements?