Hello,

I am trying to determine in one step the carryover amount of vacation hours that an employee has over and above their allowable limit.

Column C - current vacation hours in the bank

Column D - Entitlement for new Fiscal that just started

Column E - Previous Fiscal's entitlement 

Column F - Amount of previous year's Fiscal which they are entitled to carryover half (which is half)

Column G - If their current vacation balance (column C) is greater than their entitlement (column D) what is this amount (this is the amount they are over)

Column H - And if this overage is greater than their allowable carryover (column F). If true what is the amount and if false "okay" 

Thank you.