Thread: Need help with IF formulas for work timesheets
View Single Post
 
Old 01-17-2023, 08:44 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,969
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
The If formula has three parts: Test,ValueIfTrue,ValueIfFalse. You only provided a ValueIfTrue so when the False state is triggered you didn't tell the formula what to do. That is fixed by adding that to the formula in cell F6
=IF(H6>=7.6,7.6,H6)

But I would use a simpler formula in cell F6 and then copy it down
=MIN(7.6,H6)
That will give you the actual hours up to a maximum of 7.6
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote