Hello, I'm having trouble with writing a formula to calculate sick leave
payoff. If column A is hire date, column C is hour type (sick, vacation,
holiday), column C is hours of sick leave accrued, and column D is hourly
rate, I need to calculate: If the hire date is = 5 years, then sick leave
payout is 25% of accrued sick hours. I've got an IF function already for
=IF(G11="Sick Leave",(H11*0.25)*I11,0), but need to also include a function
to return the value if the date is greater than 5 years, and to return 0 if
the hire date is within 5 years. I appreciate any help!