Formula

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
.

Relevant Pages

  • Re: Date Difference Help Needed
    ... entering in your form. ... > differernce between that amount of days and the current date. ... > Maybe my original formula for Text39 is off; ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: Quiz Call - Jo
    ... I was entering so quickly my heart was racing by the ... amount and I'm sure of the answer. ... Better get on with my real job now:o) ... Prev by Date: ...
    (uk.rec.competitions)
  • Re: After Updates IE very slow!
    ... Frank S. ... > Try entering your Task Manager and look at your running ... Prev by Date: ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Virus emails. Can I tell where they originated?
    ... amount of time and I think my server may be under some type of attack. ... Frank ... Prev by Date: ...
    (microsoft.public.exchange2000.general)
  • form/subform caclulation timing
    ... I have an "order entry form" can be viewed at ... money (a set limit and limited by the amount of money they pay in). ... The refund field is calculated via subtracting the shiping ... until they get done entering the data. ...
    (microsoft.public.access.formscoding)