recogonize either "c" or "ss" as value of 24
VBA Telemetry pings you when your VBA projects fail
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,581
    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,581
    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,581
    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

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