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
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
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 IF statement - This can be a warning or you can set it to 1800 also
Try...
=MIN(A1+A2,1800)
Hope this helps!
In article <[email protected]>,
Tracey <[email protected]> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks