Thread: Time Off Accrual Spreadsheet
View Single Post
  #4  
Old 06-01-2009, 04:00 PM
respinosa respinosa is offline
Registered User
  
Join Date: 08 Jun 2006
Location: Kalifornia
MS Office Version:2003/2007
Posts: 7
respinosa is becoming part of the community
Re: Time Off Accrual Spreadsheet
Actually I "think" I figured it out! Here's what I used:
=SUM(81.57-AA3)+COUNTIF(C3:Z3,0)*5
The only think I need left to do, is if it goes negative, to make cell "AB" turn red and bold, so it stands out.

Thanks again for the help.
Reply With Quote