sethu29

08-10-2015, 11:31 PM

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