Hello friends,
I am unable to understand the mathematics behind a logic and that is why I cannot write a formula.
I have two columns, Input and Output. Based on input, the output should be generated as per criteria below
1. If the input is equal to or below 20% then output should remain same as input
2. if the input is equal to or more than 100% then the output should be half of the input
3. If the input ranges between 20% and 100% then it should calculate proper weightage and give the output.
The cells marked in yellow are the desired output i am looking at. Please help me with a formula.
Thank you
inputoutput.png
Bookmarks