Forum Discussion
What Formula Do I Use To Show A Calculation % For A Range If Result Is BETWEEN Certain Values?
I attached a sheet with an example.
What I want is a staggered range in Column D that shows a certain percentage based on the previous columns result:
If "% Increase In Value" (Column C) is in the below range, show the following percentage. Otherwise show blank. If greater than 50, show the profit % increment with 5% increases up till 90% max:
100 - 125% = 50%
125 - 150% = 55%
150 - 175% = 60%
175 - 200% = 65%
200 - 225% = 70%
225 - 250% = 75%
250 - 275% = 80%
275 - 300% = 85%
300 - 325% = 90%
325% and above = 90%
I think this requires the nested "https://www.techonthenet.com/excel/formulas/if_nested.php" or the "https://www.techonthenet.com/excel/formulas/ifs.php" function (which only works in Excel 2019 & above, but which I do have). Just not quite sure how to write it here (for column D)...
I need help to correct Column D so that it shows the correct percentage for the range (it currently shows 50% no matter what).
Help appreciated.
Dhira1360 Perhaps easiest with a small lookup table as demonstrated int eh attached workbook. end result in column F
2 Replies
- Riny_van_EekelenPlatinum Contributor
Dhira1360 Perhaps easiest with a small lookup table as demonstrated int eh attached workbook. end result in column F
- Dhira1360Copper ContributorThat works great! Thank you.