words means numbers

Z

Zack

is there a way on a time sheet that when i put Holiday or Absent it will the
know that each of the words means 8 hours holiday and 0 hours for Absent on a
time sheet template
 
P

Peo Sjoblom

Assume you put these words in column C in C2:C33

Since Absent is zero you only need to count Holidays

=COUNTIF(C2:C32,"Holiday")*8


--
Regards,

Peo Sjoblom

(No private emails please)
 
G

Gord Dibben

Zack

In a cell on your timesheet.........

=IF(A1="absent",0,IF(A1="holiday",8,A1))

If linking to another sheet..........

=IF(Sheet1!A1="absent",0,IF(Sheet1!A1="holiday",8,Sheet1!A1))


Gord Dibben Excel MVP
 
Z

Zack

ok does it mean you can put it anywhere on the spreadsheet, and then if i
type absent in a cell will it know it is 0
 
Z

Zack

when i insert the word absent in the cell then my overtime # goes to the value
January Total Hours Week 1 Overtime
Monday "absent" 8 #VALUE!
 
Top