PDA

View Full Version : Excel Formula for the below conditions



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

sethu29
08-10-2015, 11:43 PM
If A1 Value is 3845154 , the b1 cell has to reflect 0.85*3845154=3268380.9
If A2 Value is 2500000 , the b2 cell has to reflect 0.9*2500000=2250000
If A3 Value is 900000, the b3 cell has to reflect 0.10*900000=90000

Please help

Aussiebear
08-11-2015, 01:08 AM
Where do we find the volume figure for the month? From the information currently provided we are at a loss to construct any formula to assist you

p45cal
08-11-2015, 06:35 AM
=A1*VLOOKUP(A1,{0,0.1;1000000,0.9;2500000,0.85},2,TRUE)
?

ps. should the .1 be 1?