words means numbers
 

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

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)


"Zack" wrote in message
...
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

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

On Mon, 29 Aug 2005 13:51:50 -0700, "Zack"
wrote:

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

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
"Gord Dibben" wrote:

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

On Mon, 29 Aug 2005 13:51:50 -0700, "Zack"
wrote:

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

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!



"Gord Dibben" wrote:

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

On Mon, 29 Aug 2005 13:51:50 -0700, "Zack"
wrote:

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

Now why didn't I think of that? <g


Gord

On Mon, 29 Aug 2005 15:03:56 -0700, "Peo Sjoblom" wrote:

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