![]() |
#1
|
|||
|
|||
![]()
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) |
Tags |
excel 2013, excel formula |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
What is the formula for getting the percentage for time | phoenix666! | Excel | 1 | 07-29-2016 08:18 AM |
![]() |
raminraiszadeh | Project | 2 | 04-06-2015 06:38 AM |
Formula Calculation | medavidcook | Excel | 2 | 03-21-2015 03:47 AM |
![]() |
danbl | Excel | 8 | 02-23-2012 04:35 AM |
![]() |
YooNaa Kim | Excel | 1 | 06-07-2011 08:50 PM |