Thanks:  0
Likes:  0

# Thread: recogonize either "c" or "ss" as value of 24

1. "C" MEANS A MAN IS AT CENTRAL STATION
"SS" MEANS HE IS AT A SOUTH SIDE STATION
BUT ON ANOTHER WORKSHEET I WANT IT TO PUT THE VALUE OF "24" IN FOR EITHER "C" OR "SS".
IT WORKS NOW WITH THIS FORMULA FOR THE "C"!
COUNTIF('DAILYLOG"!D6,"C")*24
BUT IT ONLY WILL RECOGNIZE THE "C"
ANY HELP,, ANY ONE????

[ This Message was edited by: CAPT.PT on 2002-03-03 16:52 ]

2. Try

=IF(OR('DAILYLOG"!D6="C",'DAILYLOG"!D6="SS"),24,"")

3. On 2002-03-03 17:10, Dave Hawley wrote:
Try

=IF(OR('DAILYLOG"!D6="C",'DAILYLOG"!D6="SS"),24,"")

thanks Dave...but it didn't work!
I COPIED IT-PASTED IT SO i DIDN'T GET IT WRONG...BUT IT DIDN'T WORK

4. I actualy copied and pasted your sheet reference, which is why I got it wrong )

Try:

=IF(OR('Daily Log'!D6="C",'Daily Log'!D6="SS"),24,"")

5. your formula looks good...but I can't get it to work...any ideas why??

6. On 2002-03-03 16:50, CAPT.PT wrote:
"C" MEANS A MAN IS AT CENTRAL STATION
"SS" MEANS HE IS AT A SOUTH SIDE STATION
BUT ON ANOTHER WORKSHEET I WANT IT TO PUT THE VALUE OF "24" IN FOR EITHER "C" OR "SS".
IT WORKS NOW WITH THIS FORMULA FOR THE "C"!
COUNTIF('DAILYLOG"!D6,"C")*24
BUT IT ONLY WILL RECOGNIZE THE "C"
ANY HELP,, ANY ONE????

[ This Message was edited by: CAPT.PT on 2002-03-03 16:52 ]
Not sure I understand fully, also because you didn't tell what to compute when DAILYLOG!D6 does not house one of {"C","SS"}, but try:

=24*((DAILYLOG!D6="C")+(DAILYLOG!D6="SS"))

If D6 has values with spaces around, you might not get the result. You can of course try:

=24*((TRIM(DAILYLOG!D6)="C")+(TRIM(DAILYLOG!D6)="SS"))

to check that out.

7. WHEN i PUT IN YOUR FORMULA i GET A #VALUE RETURN
i HAVE A WORKSHEET CALLED DAILY LOG..ON IT i PUT IN EITHER A "C" OR "SS MEANING ...WHATEVE....ON ANOTHER WORKSHEET CALLED "flsa" I REFER BACK TO THE DAILY LOG WORKSHEET AND LOOK AT THE "C" OR "SS", BUT NOW i WANT THEM TO BE RECOGNIZED AS THE NUMBER OR VALUE OF 24??? DOES THAT HELP??

## 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
•