Try something like: =MIN(SUM(A1:B1),80)
where the 2 cells are A1 and B1
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Pepper233" wrote in message
...

I need the IF function to add up two cells and if the sum is greater than
or
equal to 80, then the cell needs to read "80," if the sum is less than 80
I
just want it to show whatever number it calculates (79 and below).

This is for a timesheet with overtime.

Thank you for your help!!