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

CAPT.PT · Mar 4th, 2002, 10:50 AM

"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 · Mar 4th, 2002, 10:54 AM

What's your cell format on the destination cell?

Anne Troy · Mar 4th, 2002, 10:57 AM

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 · Mar 4th, 2002, 10:58 AM

Any replies should be directed to:

http://www.mrexcel.com/board/viewtop...1138&forum=2&4

Mar 4th, 2002, 10:54 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	What's your cell format on the destination cell? __________________ ~Anne Troy

Mar 4th, 2002, 10:57 AM	#3
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	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

Mar 4th, 2002, 10:58 AM	#4
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Any replies should be directed to: http://www.mrexcel.com/board/viewtop...1138&forum=2&4 __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 10:50 AM	#1
CAPT.PT New Member Join Date: Mar 2002 Posts: 32	"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??????