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 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
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
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
=A1*VLOOKUP(A1,{0,0.1;1000000,0.9;2500000,0.85},2,TRUE)
?
ps. should the .1 be 1?
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Posting Permissions
Reply With Quote
