Forum Discussion

Dhira1360's avatar
Dhira1360
Copper Contributor
Apr 11, 2021
Solved

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.

Resources