15,039,149 members
1.00/5 (1 vote)
See more:
dear ,
i have a problem to derive the formula
my scenario is:

if salary of a person is less than 160,he is charged by 1%
if salary of a person is less than 260,he is charged by 1% of 1st 160 and 15% of balance
if salary of a person is less than 100,he is charged by 1% of 1st 160 and 15% of next 100000 and 25% of balance

if i could get its formula, i would be very grateful

please help me!!!!
Posted
Updated 20-Sep-12 2:00am
v2
Comments
[no name] 20-Sep-12 7:27am

How exactly is this a problem?

Solution 1

By taking a tour of these samples, I'm sure that you can formulate the required formula on your own.

MSDN Tour[^]
Spread Sheet tour[^]
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Top Experts
Last 24hrsThis month
 Richard MacCutchan 175 OriginalGriff 143 CPallini 45 Patrice T 30 Stefan_Lang 30
 OriginalGriff 3,358 Richard MacCutchan 1,875 Richard Deeming 1,848 CPallini 1,148 Dave Kreskowiak 809

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900