Apr 11 2021 11:43 PM
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.
Apr 12 2021 12:18 AM
Solution@Dhira1360 Perhaps easiest with a small lookup table as demonstrated int eh attached workbook. end result in column F
Apr 13 2021 04:29 PM
Apr 12 2021 12:18 AM
Solution@Dhira1360 Perhaps easiest with a small lookup table as demonstrated int eh attached workbook. end result in column F