I have 2 rows in my spreadsheet
A B C
Time Account Entitlement Remainder
1 Other Leave 11 xx
2 Annual Leave 15 xx
What I wants is that if I take a leave it will start deducting from Other Leave first until the "Other Leave" drops to zero then will it start deducting from the "Annual Leave"
Bookmarks