Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

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

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

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

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    What's your cell format on the destination cell?
    ~Anne Troy

  3. #3
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Any replies should be directed to:

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

Some videos you may like

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
  •