Thanks:  0
Likes:  0

# Thread: MAYBE I NEED TO EXPLAIN BETTER

1. I am making a payroll program which consists of differant worksheets.
On one worksheet called "DAILY LOG', I log men in at differant stations, (C, meaning he is at central station, SS meaning he is at a South Station. On this worksheet those letters mean nothing more...nothing less.
however, on this worksheet, the letter S, means he is off sick and puts a value of 11.2 hrs. in the sickleave cell.
if I enter a number, forinstance 12, that puts 12 hrs. in the cell or column for 12 hrs. OVERTIME.

Now, on another worksheet, I refer to a certain column to read what men were on duty.
If this cell corresponds to a man that was working at the Central fire station, I want to enter the value of 24 in this cell. (SS would mean he is on duty at the South Station and enter a value of 24 in the cell.
I am using the Formula: =COUNTIF('Daily Log'!D6,"C")*24
this works, butI also would like to add "SS"to it, so that if it see's a C or a SS it will add the number 24 to the cell in second worksheet.
Does this make any clearer sense as to what I am trying to do???

2. On 2002-03-04 14:49, CAPT.PT wrote:
I am making a payroll program which consists of differant worksheets.
On one worksheet called "DAILY LOG', I log men in at differant stations, (C, meaning he is at central station, SS meaning he is at a South Station. On this worksheet those letters mean nothing more...nothing less.
however, on this worksheet, the letter S, means he is off sick and puts a value of 11.2 hrs. in the sickleave cell.
if I enter a number, forinstance 12, that puts 12 hrs. in the cell or column for 12 hrs. OVERTIME.

Now, on another worksheet, I refer to a certain column to read what men were on duty.
If this cell corresponds to a man that was working at the Central fire station, I want to enter the value of 24 in this cell. (SS would mean he is on duty at the South Station and enter a value of 24 in the cell.
I am using the Formula: =COUNTIF('Daily Log'!D6,"C")*24
this works, butI also would like to add "SS"to it, so that if it see's a C or a SS it will add the number 24 to the cell in second worksheet.
Does this make any clearer sense as to what I am trying to do???
=OR('Daily Log'!D6="C",'Daily Log'!D6="SS")*24

Regards,

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•