fast formula help
Posted: Mon Feb 15, 2010 8:37 am
Dear ALL;
i define an earning (ann_sal) and a deduction (assur) is a percentage of total earnings i need to define another deduction (IR) :
X = (10% * ann_sal ) - (assur)
for this X is divided into slices
between X=0 and X= 1000 ->IR = 10%*X
between X =1000 and X=2000 -> IR=15%*X
when X>2000 IR=25% *X
example1 : X= 1800
IR = (10% * 1000) + (15% * 800)
example2 : X= 2300
IR = (10% * 1000) + (15% * 1000) + (25% * 300)
example3 : X= 3500
IR =( 10% * 1000) + (15% * 1000 ) + ( 25% * 500)
CAN ANYONE HELP ME TO DEFINE THIS FORMULA...please
best regards
SAMI
i define an earning (ann_sal) and a deduction (assur) is a percentage of total earnings i need to define another deduction (IR) :
X = (10% * ann_sal ) - (assur)
for this X is divided into slices
between X=0 and X= 1000 ->IR = 10%*X
between X =1000 and X=2000 -> IR=15%*X
when X>2000 IR=25% *X
example1 : X= 1800
IR = (10% * 1000) + (15% * 800)
example2 : X= 2300
IR = (10% * 1000) + (15% * 1000) + (25% * 300)
example3 : X= 3500
IR =( 10% * 1000) + (15% * 1000 ) + ( 25% * 500)
CAN ANYONE HELP ME TO DEFINE THIS FORMULA...please
best regards
SAMI