Hi,
I have situation here with our salary sheet.
The concerning issue is, if present days are Zero in E14 an Earned day is 1 in J14 as employee has One Leaves
Allowed G14, the Salary Paid showing in AG14 should be zero then, as because present days are Zero in E14. which is not working
Employee has One Leaves Allowed in G14 because of that employee get one day extra wages. But this should not be True if present days are Zero in E14.
But If present days are not zero and Earned day is 1 in J14 then Salary Paid should be Piad by calculating total present days & Earned days
Please see the attach image.
error.JPG
Formula i'm using in AG14:
Please help to fix this issue.
Thanks
Best,
Bookmarks