Re: Salary Calculator..

Member

July 19, 2012 at 12:35

Post count: 24

#19694

I really appreciate your response. However i've got another problem. I've done like you explained. But can you tell me a perfect formula so that the amount in salary is calculated based on his days worked. i need to calculate salary based on employees work days. The formula i'm using is as below. But the calculation result isn't as it should be. I first used a simple formula which obviously was wrong. But now again the below formula seems to b wrong. If you can tell me correct formula i'll be grateful.

Basic = (({Gross Breakup}*50/100)/[Days in Period])* ([Days Worked]+<Holiday_Days>+[Number of Day Offs])

Waiting for your answer.
Thanks in anticipation..
Khalid