Hi Judy,
Thank you for your response, but this solution is not matching as i required.
I required to establish slabs which are in the system but i required that %age should apply on only differential of lower and upper limit, if i have some fix amount for that slabs of lower limit that should also includes in it and this is for a whole year calculation which divides to per month. To explain more i give example below:
Like table i shared, in 3rd slab 600,000 to 2,000,000 have 10% and 15000 fix.
if a person annual total is 1,000,000 then
his calculation is for till 600,000 fix amount is 15000 plus differential of (600,000 and 1,000,000=400,000) on that 400,000 we will apply %age which is 400,000*10%=40000.
total against 1,000,000 is 15000+40,000=55000 annual.
if i required per month then 55,000/12=4583.333 is the amount per month i required to book.
Please look this scenario, how to book it. Thanks
Regards,
Ali Waqas
