Formula 0%, 5%, 10%, 15%, 20%, 25%, 30%

0%, 5%, 10%, 15%, 20%,25%, 30 % Formula

=IF(N51<250000,N51*0%,0)+IF(AND(N51>250000,N51<500000),(N51-250000)*5%,IF(N51>500000,250000*5%,0)) +IF(AND(N51>500000,N51<750000),(N51-500000)*10%,+IF(AND(N51>750000,N51<1000000),(N51-750000)*15%,IF(N51>1000000,750000*15%,0)) +IF(AND(N51>1000000,N51<1250000),(N51-1000000)*20%,IF(N51>1250000,1000000*20%,0))+IF(AND(N51>1250000,N51<1500000),(N51-1250000)*25%,IF(N51>1500000,1250000*25%,0))+IF(N51>1500000,(N51-1500000)*30%,0)

5%    FORMULA

=IF(Q48<250000,Q48*0%,0)+IF(AND(Q48>250000,Q48<500000),(Q48-250000)*5%,IF(Q48>500000,250000*5%,0))

0%  ------ FORMULA

=IF(Q48<250000,Q48*0%,0)

5%

=IF(Q48<250000,Q48*0%,0)+IF(AND(Q48>250001,Q48<500000),(Q48-250000)*5%,IF(Q48>500000,250000*5%,0))

10%

=IF(Q48<500000,Q48*0%,0)+IF(AND(Q48>500000,Q48<750001),(Q48-500000)*10%,IF(Q48>750000,250000*10%,0))

15%

=IF(Q48<750000,Q48*0%,0)+IF(AND(Q48>750001,Q48<1000000),(Q48-750000)*15%,IF(Q48>1000000,250000*15%,0))

20%

=IF(Q48<100000,Q48*0%,0)+IF(AND(Q48>1000000,Q48<1250000),(Q48-1000000)*20%,IF(Q48>1250000,250000*20%,0))

25% 

=IF(Q48<1250000,Q48*0%,0)+IF(AND(Q48>1250001,Q48<1500000),(Q48-1250000)*25%,IF(Q48>1500000,250000*25%,0))

30%

= IF(Q48<1500001,0,((Q48-1500000)*0.3))

0%, 5%, 10%, 15%, 20%,25%, 30 % Formula

=IF(Q48<250000,Q48*0%,0)+IF(AND(Q48>250000, Q48<500000),( Q48-250000)*5%,IF(Q48>500000,250000*5%,0))+IF(AND(Q48>500000, Q48<750000),( Q48-500000)*10%,+IF(AND(Q48>750000, Q48<1000000),( Q48-750000)*15%,IF(Q48>1000000,750000*15%,0))+IF(AND(Q48>1000000, Q48<1250000),( Q48-1000000)*20%,IF(Q48>1250000,1000000*20%,0))+IF(AND(Q48>1250000, Q48<1500000),( Q48-1250000)*25%,IF(Q48>1500000,1250000*25%,0))+IF(Q48>1500000,( Q48-1500000)*30%,0))