#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
In B2:
=A1*(IF(A1>=20000,0.2,IF(A1>=10000,0.15,IF(A1>0,0. 1;"") ))) |
#3
|
|||
|
|||
Another one:
=$A1*(0.1 + ($A1>10000)*0,05 + ($A1>20000)*0,05) Advantges: arithmetical operators are faster; no limit for number of nested IF() functions |
#4
|
|||
|
|||
hi xor
thank you quick response , but appear some error massage in above formula. |
#5
|
|||
|
|||
HI ArviLaanemets
thank you quick response , but appear some error massage in above for formula |
#6
|
|||
|
|||
I think there is a space too much in the last IF (0. 1). Try:
=A1*(IF(A1>=20000,0.2,IF(A1>=10000,0.15,IF(A1>0,0. 1;"") ))) |
#7
|
|||
|
|||
Oh, now I see that there is a problem with this site. It automatically puts that extra space in 0. 1
|
#8
|
|||
|
|||
See the attached
|
#9
|
|||
|
|||
hi xor
you're amazing .its working thank you very much. |
#10
|
||||
|
||||
xor, you are also mixing commas and semi-colons as parameter separators...
|
#11
|
|||
|
|||
Sorry about that. I usually am checking and editing formulas to US format in postings, but this time I was distracted meanwhile.
|
Tags |
excel 2013, excel formula |
|
Similar Threads | ||||
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 |
Calculation of Percentage Completion of Summary Tasks | raminraiszadeh | Project | 2 | 04-06-2015 06:38 AM |
Formula Calculation | medavidcook | Excel | 2 | 03-21-2015 03:47 AM |
Formula calculation | danbl | Excel | 8 | 02-23-2012 04:35 AM |
Excel 2010 formula rounds - arithmetic average calculation | YooNaa Kim | Excel | 1 | 06-07-2011 08:50 PM |