percentage calculation formula
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)
|