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: 
=$AB14-T14-($AD14*$N14)+X14
Please help to fix this issue.

Thanks

Best,