recogonize either "c" or "ss" as value of 24

[CAPT.PT]

"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

 

[Dave Hawley]

Try

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

 

[CAPT.PT]

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

 

[Dave Hawley]

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,"")

 

[CAPT.PT]

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

 

[Aladin Akyurek]

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.

 

[CAPT.PT]

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??