I need to create a formula to calculate the total number of regular hours worked.
I need the new cell to = 80 if the total number of hours worked is greater than 80 and if it is less than 80 to = the original number for hours worked.
iMac, iOS 8.4
assuming you enter the hours in cell B2
the formula would be:
=min(B2, 80)
another way is:
=if(B2 > 80, 80, B2)
assuming you enter the hours in cell B2
the formula would be:
=min(B2, 80)
another way is:
=if(B2 > 80, 80, B2)
Can you share any confusion you have that prevents this topic from being solved?
Min stands for minimum and returns the minimum value of the two arguments.
How to write a if statement
