Forum Discussion
smallest value of 2 values
I am trying to make a spreadsheet for PTO accruals. the formula is HRS worked / a fixed value for PTO accruals. this equates to a set value for a weekly PTO accrual. if a min amount of HRS worked ...
That could be:
=MIN( 1.848, hours_worked * 0.04 )
It will calculate hours_worked X 0.04 and will always return the lower of that calculation and 1.848.
hours_worked, obviously, refers to a cell with the hours worked.