Hi

how to put percentage calculation formula following example.
According to the net profit need to change percentage amount.



EX-
Net Profit - 20000(cell-A1)

high in 20000 then 20% net
Net profit between in 10000 and 20000then 15% net
Net profit less 10000 then 10% net

Above percentages value in net profit need fill automatically (Ce11-B2)
Net profit -16000
15% net-15/100=2400(this amount need fill automatically(Ce11-B2)