SOLVED

New Contributor

# 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 "IF"  or the "IFS" 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.

2 Replies
best response confirmed by Dhira1360 (New Contributor)
Solution

# Re: What Formula Do I Use To Show A Calculation % For A Range If Result Is BETWEEN Certain Values?

@Dhira1360 Perhaps easiest with a small lookup table as demonstrated int eh attached workbook. end result in column F

# Re: What Formula Do I Use To Show A Calculation % For A Range If Result Is BETWEEN Certain Values?

That works great! Thank you.