recogonize either "c" or "ss" as value of 24
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

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

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    "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. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try

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



  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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. #5
    New Member
    Join Date
    Mar 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  6. #6
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,779
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    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. #7
    New Member
    Join Date
    Mar 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com