Forum Discussion
Excel Formula
I am not an expert in excel formulas and I want to write formula that reflect the following:
If I have a three brackets
(0-70) / (70-100) / (any number over 100)
And If there is any number falls within these brackets will have certain percentage to be multiplied in:
5% for (0-70) / 15% for (70-100) / 100% (any number over 100)
Also, if the number is 75, so the percentage of 5% will be applied on the 70 and 15% will be applied on the remaining 5
Same concept if the number is 105
Any assistance?
If I have a three brackets
(0-70) / (70-100) / (any number over 100)
And If there is any number falls within these brackets will have certain percentage to be multiplied in:
5% for (0-70) / 15% for (70-100) / 100% (any number over 100)
Also, if the number is 75, so the percentage of 5% will be applied on the 70 and 15% will be applied on the remaining 5
Same concept if the number is 105
Any assistance?
1 Reply
Ahmed2500 Quick and ugly since I'm in a hurry, but put the number to be evaluated into E3 and use this formula:
=IF(0>$E$3>70,$E$3*0.05,IF(71>$E$3>99,(0.05*70)+(($E$3-70)*0.15),IF($E$3>100,(0.05*70)+(0.15*30)+($E$3-100))))
Also, here is a better forum for questions about Excel:
