Hi. I've been searching lots of forums all morning and cannot find a solution to my problem.
I'm trying to have a formula check a single number against multiple criteria and return a single solution.
Here is the data:
Check if this number "61108" is between the numbers in columns A and B, and then return the % in column C:
- 50,000 15%
50,001 75,000 25%
75,001 100,000 34%
100,001 335,000 39%
335,001 10,000,000 34%
10,000,001 15,000,000 35%
15,000,001 18,333,333 38%
18,333,334 35%
I hope this makes sense.
Bookmarks