populate cells based on mulitple characters

  • Thread starter Thread starter cake123
  • Start date Start date
C

cake123

i am creating a schedule, based on six day work week. if you work th
first five days (m-f), you get the sixth off (sat). We cycle the of
day every week between the employees.

i'm trying to automate the saturday cell based on the what is inserte
in the previous cells. currently, i place an 8 in those cells an
placed this formula in the saturday cell... =IF(SUM(C4:G4)<40,8,0)

but... and here is where the question comes in... if someone takes
personal say, vacation, or sick day, i can't insert the number 8.
insert a letter which tallies on a separate sheet the number o
vacation days used etc...v p s

is there anyway to add something to the current formula or change th
formula to recognize 'something' is inserted in the cells and to no
schedule a day in the saturday cell?

thanks for your comments in advance
 
You could count the number of entered cells as well.

=IF(AND(COUNTA(C4:G4)<5,SUM(C4:G4)<40),8,0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top