Greater than formula

T

Tracey

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
 
W

wjohnson

Try the following:
=IF(A1+B1<=1800,A1+B1,IF(A1+B1>1800,1800,"Check"))
The "Check" can be any value you want for the false part of the last I
statement - This can be a warning or you can set it to 1800 als
 
Top