Formula

[Guest]

I am using this formula to deduct for sick time, "=COUNTIF(K17:AL18,"S")*8"
and it works well. I need to add that if the TOTAL Cell (n44) is less than
one an error must flash to prevent the formula from entering a negative
amount.

Thanks for any suggestions you may offer.

Frank

 

[Dave O]

Need help interpreting your post: you need to add sick time if the
total cell is less than one?

 

[Guest]

Dave,

I need to stop the formula from deducting 8 hours from the sick time total
if the person does not have enough sick time balance. I would like to triger
a message stating that the person does not have enough sick time to complete.

 

[RagDyeR]

What formula do you have in N44?

How is the return of your Countif formula deducted?

The Countif() accumulates the "sick time" for a particular time period, but
you haven't told us what formulas you have in other cells that perform
calculations with *that* Countif() return.

It's *those* formulas that could be put in a validation setting that can,
for example, turn red when they reach a pre-arranged criteria.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

Dave,

I need to stop the formula from deducting 8 hours from the sick time total
if the person does not have enough sick time balance. I would like to
triger
a message stating that the person does not have enough sick time to
complete.