I am looking for a payroll formula. The formula will combine data from two
separate pay periods.
For each day worked, employee receives $65 not to exceed $1,300 in total
from two pays.
Example:
Payroll 1, employee works 12 days and receives $780.00 ($65 x 12)
Payroll 2, employee works 12 days, this works out to $780, but exceeds the
maximum $1300 payment allowed.
ie: The second pay needs a result of either the actual calculation if the
total of 2 pays is 1300 or less or a calculation of 1300 less 780, indicating
the actual payment allowed, ie: $520