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

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

this looks good, but doesn't work??????

 

[Anne Troy]

What's your cell format on the destination cell?

 

[Anne Troy]

Captain: Please post your question once and stay with it? Now I see that you're already getting help in the duplicate question. You can always bring your question back to the top of the list by just replying in it again.

 

[Anne Troy]

Any replies should be directed to:

http://www.mrexcel.com/board/viewtopic.php?topic=1138&forum=2&4