GVN KUMAR
Member
after a long time, we are again asking sir
we are not able to your formula editing but using copy and paste formula not additions to your formula sir
so our tax rate changes and insert new regime sir
could you help sir
this slab rate is attached sir
the same way sir additional 3 slabs were inserted this year sir
could you help sir
Your Excel knowledge is beyond our imagination Your formula is too small to be easy but we could not edit it to understand it to change. We changed it a little to fit the lost garment. 3 additional slabs were laid this year.
=ROUND(SUMPRODUCT(--(B7>250000*{0;1;2;4}),--(B7-250000*{0;1;2;4}),{0;0.0515;0.1545;0.103}),0) ← its working and 10000000% correct sir
Thank you for devoting your precious time to us
we are not able to your formula editing but using copy and paste formula not additions to your formula sir
so our tax rate changes and insert new regime sir
could you help sir
this slab rate is attached sir
the same way sir additional 3 slabs were inserted this year sir
could you help sir
Your Excel knowledge is beyond our imagination Your formula is too small to be easy but we could not edit it to understand it to change. We changed it a little to fit the lost garment. 3 additional slabs were laid this year.
=ROUND(SUMPRODUCT(--(B7>250000*{0;1;2;4}),--(B7-250000*{0;1;2;4}),{0;0.0515;0.1545;0.103}),0) ← its working and 10000000% correct sir
Thank you for devoting your precious time to us