Hi all,
I am somewhat of a novice with Excel so please excuse my ignorance. I am trying to write a formula which will ensure that a given number (percentage actually) is returned when the number entered into my entry field (B9) is within a certain range.
The ranges and related values that I have are as follows:-
Up to $1,000,000 : 0.250%
1,000,001 - 2,000,000 : 0.225%
2,000,001- 3,000,000 : 0.200%
3,000,001 - 5,000,000 : 0.175%
5,000,001 - 7,500,000 : 0.150%
7,500,001 and over : 0.125%
So, for instance if I were to enter a value of $4,250,000 into cell B9 it should return a value of 0.175% into cell C9.
Does anyone have any advice as to how I can solve this issue? Any help you can provide will be greatly appreciated! I have attached my spreadsheet. Thank you.
Bookmarks