See this for simple formula solution.
Lear More@
www.ExcelVbaLab.Com
On Thursday, August 20, 2015 at 12:02:41 PM UTC+5:30, Ashok Soni wrote:
>
> Dear Pankaj Sharma,
> thanks of lot, i will make it on other sheet.
> i had sent it ( incentive slab for example to understand what i am looking
> )
Dear Pankaj Sharma,
thanks of lot, i will make it on other sheet.
i had sent it ( incentive slab for example to understand what i am looking )
your formula is best way for me, if i need more help regarding this i will
disturb you again.
thanks again
On Thu, Aug 20, 2015 at 10:56 AM, Pankaj Sharma
Dear Ashok,
I don't think there is any easiest way to calculate this with excel
formula's.
You can do with run a macro or better if you make a slab chart on the right
side or other sheet to calculate the same. This will be easy if you have to
change slab criteria in future.
On Wed, Aug 19, 20
Dear Rajan Sir,
I need a formula in excel which can calculate commission on target amount.
i describe as bellow:
1. suppose i have 10 branches and more than 3 employee in each.
2. i have different % slab of commission.
3. commission should be calculate stab by stab.
i have explain it in excel
See the attached
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rashid Khan
Sent: 10 September 2012 1:20
To: excel-macros
Subject: $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per
Ta
