Log In
Register
Home
Power Query
Word
May 3, 2019
Offline
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.
See Answer
Trusted Members
Moderators
November 1, 2018
Offline
Assuming the negative values in your current version should not really be there, you could just use:
=IF(MAX(B2-C2,0)-D2/2>0,MAX(B2-C2,0)-D2/2,"ok")
Answers Post
1 Guest(s)
