Hi dear, Nice to see you after a long time.
I m stuck somewhere, I have to calculate salaries, BUT I HAVE A FORMULA PROBLE AS PER ATTACH SHEET, PLS HELP ME.
THANKS IN ADVANCE
my requirements.xls
Hi dear, Nice to see you after a long time.
I m stuck somewhere, I have to calculate salaries, BUT I HAVE A FORMULA PROBLE AS PER ATTACH SHEET, PLS HELP ME.
THANKS IN ADVANCE
my requirements.xls
Hello..22 people viewed n no reply, it is realy difficult ...pls give ur littl time
If this formula =E9/G9*H9 gives you the correct result 10 why do you use different formula for other rows?
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
HI, ALKEY, THANKS FOR REPLY
I understand it, but here the senerio ls different.. actually, actual salary is 260..but we transfer to bank only basic salary 200. but if the working days is not completed full month 26 days, the deduction will be made on base of actual salary 260.
I put formula, but it giving me wrong result when a employee is newly join and worked only 1 or 2 days.
in short.. if the month is complete i.e. 26 days, than salary amount will be 200, but if any less day than deduction will be based on actual 260.
pls help
Mathematically, that is exactly what is going to happen if someone works for 1-2 days. The equation is correct.
The maximum deduction, theoretically, if a person was to work 0 days would be the full 260. But since it's being deducted from the max payout of 200, it would result in -60 pay.
The equation works perfectly for the requirements you have... It's the requirements that need to be re-evaluated.
Going for Guru! Click the Star to the bottom left of this post if I helped!
thanks... I m still not clear .. my boss told me to transfer SALARY to bank only basic salary 200 as first payment of salary. and second payment 60 will be paid after 15 days. but any deduction will be done in first payment based on 260.
and also if working days are less and salary calculation is not enough or less than first payment 200, than the same salary will be paid.
so if one person has 25 days. its mean his 1 days salary will be deducted from basic salary so amount wil be 190.
but
if any new person, who has only 1 day and the amount is lesser than first payment (200), so 1 day salary based on 260 will be transferred.
hope it will make you clear to help me.
hi...any update pls?
Try this now
=IF(E7/G7*H7>F7,E7/G7*H7-(E7-F7),E7/G7*H7)
thanks alkey, it works perfectly same what I was looking..I m very near to solve my problem.
but I have now I think last problem which appeared after this formula..
if days are 19 than salary will be 190 according to your good formula. cuz there is not balance salary for second payment after 15 days.
if days are 21 than salary will be 150 according to your good formula. cuz we have to pay second payment (260-200) after 15 days.
Now pls help me to give some formatting or some message, so that it can tell me that there is balance payment of this person 60 for second payment. otherwise how will I know that this person has finished salary or some balance amount is payable????
plsssss
my requirements 22.xls
Last edited by tariqnaz2005; 10-01-2013 at 01:09 PM.
I am glad that the formula worked as you desired. Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks