• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

PAY SCALE CALCULATING

N

nkms143

Member
Hi Friends, I have stucked up in the middle of Preparing a Pay Scale Sheet.

The Sample Sheet is herewith Attached. what i want is if the Pay Scale of an X is say
Rs.62-2-80-4-100. Then he should start with the initial Basic Pay at RS.62 per month then it will increases by 2 as per pay-scale i.e the pay will be 62 after a year (12 Months) and another Rs.2 in 2nd year i.e 64 and goes on increasing till it reaches 80 (in this case it will takes 4 Years)and then it will increases to Rs. 4 as every year as per pay scale and from 5th Year the Basic Pay will be 84 and goes on Increasing till it reaches 100.
Is there any formula to calculate this type of Pay Scale.

How to calculate if the Pay scale is
1665-40-1825-50-2075-60-2375-75-2750-90-3200.
 

Attachments

Hi ,

I doubt that a formula solution is possible , since some of them have 14 slabs !

It will be possible to write a UDF ; is this acceptable ?

Narayan
 
Hi,

See the file, I hope this will meet your expectation.

Here are some assumption I had made and if they don't meet the exact data than the code will need tweak.

The assumption is the cell in column B is going to contain ODD numbers of number like a-b-c-d-e here a,b,c,d,e is 5 (odd) or like a-b-c-d-e-f-g 7 again odd.

The code is in file it is giving error on row 91 which I had marked in Orange because it contains even numbers. Just make it ODD and it will give correct result.

I hope this is only what you want.

Regards,
 

Attachments

sorry... i have seen the post bit late for appreciation.

Thank you very much sir for your co-operation......
you are marvellous.
 
You must log in or register to reply here.
Back
Top