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)

In B2:

=A1*(IF(A1>=20000,0.2,IF(A1>=10000,0.15,IF(A1>0,0. 1;"") )))

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

hi xor
thank you quick response ,
but appear some error massage in above formula.

HI ArviLaanemets
thank you quick response ,
but appear some error massage in above for formula

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;"") )))

Oh, now I see that there is a problem with this site. It automatically puts that extra space in 0. 1

See the attached

Attached Files

Help_yoyo4.xlsx (9.9 KB, 12 views)

hi xor
you're amazing .its working
thank you very much.

xor, you are also mixing commas and semi-colons as parameter separators...

Sorry about that. I usually am checking and editing formulas to US format in postings, but this time I was distracted meanwhile.