View Single Post
 
Old 11-15-2017, 07:20 AM
yoyo4 yoyo4 is offline Windows 10 Office 2013
Novice
 
Join Date: Nov 2017
Posts: 14
yoyo4 is on a distinguished road
Default 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)
Reply With Quote