Try...

=MIN(A1+A2,1800)

Hope this helps!

In article ,
Tracey wrote:

What is the correct formula for this situation:

A1 + A2 = 1900 but if 1900 is greater than 1800 = 1800

the reason, my staff can only accumulate sick time hours to a maximum of
1800.

thanks
Tracey