Formula 0%, 5%, 20%, 30% Above

1.           izfr’kr fudkyus dk lq= 250000 ij ’kwU; izfr’kr] 250001 ls 500000 rd ¼250000 ij ½ 5 izfr’kr] 500000 ls 1000000 rd 20 izfr’kr] 1000000 ls Åij dh jkf’k ij 30 izfr’kr] fudkyus dk lq=

1.    250000 ij ’kwU; izfr’kr    =IF(N47<250000,N47*0%,0)

2.    250001 ls 500000 rd ¼250000 ij ½ 5 ifr’kr] =IF(AND(N47>250000,N47<500000),(N47-250000)*5%,IF(N47>500000,250000*5%,0))

3.    500000 ls 1000000 rd 20 izfr’kr] =IF(AND(N47>500000,N47<1000000),(N47-500000)*20%,IF(N47>1000000,500000*20%,0)) 

4.    1000000 ls Åij dh jkf’k ij 30 izfr’kr

=IF(N47>1000000,(N47-1000000)*30%,0)

lHkh dj ,d lkFk lq= yxkuk

=IF(N47<250000,N47*0%,0)+IF(AND(N47>250000,N47<500000),(N47-250000)*5%,IF(N47>500000,250000*5%,0))+IF(AND(N47>500000,N47<1000000),(N47-500000)*20%,IF(N47>1000000,500000*20%,0))+IF(N47>1000000,(N47-1000000)*30%,0)