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

CAPT.PT · Mar 3rd, 2002, 05:50 PM

"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 · Mar 3rd, 2002, 06:10 PM

Try

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

CAPT.PT · Mar 3rd, 2002, 06:57 PM

Quote:

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 · Mar 3rd, 2002, 08:49 PM

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

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

Aladin Akyurek · Mar 4th, 2002, 11:03 AM

Quote:

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 · Mar 4th, 2002, 12:00 PM

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

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

Mar 3rd, 2002, 05:50 PM	#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???? [ This Message was edited by: CAPT.PT on 2002-03-03 16:52 ]

Mar 3rd, 2002, 06:10 PM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Try =IF(OR('DAILYLOG"!D6="C",'DAILYLOG"!D6="SS"),24,"")

Mar 3rd, 2002, 08:49 PM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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,"")

Mar 4th, 2002, 10:47 AM	#5
CAPT.PT New Member Join Date: Mar 2002 Posts: 32	your formula looks good...but I can't get it to work...any ideas why??

Mar 4th, 2002, 12:00 PM	#7
CAPT.PT New Member Join Date: Mar 2002 Posts: 32	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??