Hi Everyone,
I am in a job related to sales where we use Excel in a different ways to analyze our daily, weekly & monthly Sales, Now i am making a format for weekly Sales Analysis in which i include Incentives details as well on the basis of Trend on month closing now we have 3 different Slabs to earn Incentives which i mentioned in three different columns starts from 90%, 90.00% - 94.99% with different rate per pack sold, 95.00% - 99.99% different rate per pack sold & on 100.00% & Above different rate per pack sold, Now what i want let me give Example:
Product------Trend-------90.00% - 94.99%---------95.00% - 99.99%------100.00% & Above-------Final Incentive
A---------------92%-----------100---------------------------150-------------------------250------------------------?
B---------------85%-----------Not Eligible------------------Not Eligible---------------Not Eligible---------------?
C---------------102%----------100--------------------------150-------------------------250------------------------?
I want final Incentive which pick automatically by using condition & criteria according to trend, I hope i am able to make you understand what i want..
Regards
Bookmarks