sethu29
08-05-2015, 05:42 AM
Hi Support,
If a value under the parameters, should reflect the result. Could some help with excel formula
The Volume up upto 10 Lac per month should reflect = 0.10 * Actual Volume
Volume above 10 lac but less than 25 Lac per month = 0.9 * Actual Volume
Volume above 25 Lac per month = 0.85 * Actual Volume
If a value under the parameters, should reflect the result. Could some help with excel formula
The Volume up upto 10 Lac per month should reflect = 0.10 * Actual Volume
Volume above 10 lac but less than 25 Lac per month = 0.9 * Actual Volume
Volume above 25 Lac per month = 0.85 * Actual Volume