Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Formula
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count Formula
=MAX(0,your_formula)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Dave" wrote in message oups.com... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using the $ in a count formula | Excel Discussion (Misc queries) | |||
Creating a Count formula | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
More Help Needed with Count formula | Excel Worksheet Functions | |||
Count numbers formed from another formula | Excel Discussion (Misc queries) |