Count Formula

D

Dave

I have a formula in place that works out how many holidays are left for
employees. It counts down the days left for the workers, what I want it
to do now is for it to stop at 0. Once zero is reached it sticks to
zero and does not display -1, -2 and so on if they go over the alloted
holidays left.
 
B

Bob Phillips

=MAX(0,your_formula)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top