Hello,
I need help please for an automatic/ semi automatic % finder.
I Need to find which % of discount is a Net price, from a Full price.
We have 5 possible groups:
A. Under 49.99%
B. From 50% to 50+5%
C. from 50+5+1% to 50+5+5% (to 50+10%)
D from 50+10% to 50+10+5% (to 50+15%)
E. from 50+15+1% to 50+15+5 and higher.
Considering the upper rules, I want to ask if it's possible to find from the input of full and net price, to exactly which % it's =?
I attach my actual Excel Formula and some examples, please view it to understand better.
So, a % discount finder considering the logic of the discount groups.
Bookmarks