populating cells based on references from other cells - Page 2
populating cells based on references from other cells
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: populating cells based on references from other cells

  1. #11
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Yes, that's because you didn't include that specification in your original requirements. Should I incorporate that one too?

    [ This Message was edited by: Mark W. on 2002-04-17 16:04 ]

  2. #12
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Okay, that was easy enough. Use...

    =IF(AND($A2>=LEFT(C$1,4),$A2<=RIGHT(C$1,4)),"X",
    IF(AND($B2>LEFT(C$1,4),$A2<=RIGHT(C$1,4)),"X",
    IF(AND($A2>$B2,$A2<=RIGHT(C$1,4)),"X",
    IF(AND($A2>$B2,$B2>LEFT(C$1,4)),"X",""))))

    ...as before. This is just like writing a CASE statement... just think about the conditions you want to display an "X" and incorporate it into the nested IF.

    [ This Message was edited by: Mark W. on 2002-04-17 15:27 ]

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

    Default

    Perfect! I'll make sure I give you the credit when my supervisor and coworkers see it.

    You get the gold star for the day!!

  4. #14
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-04-17 16:15, jennfurr wrote:
    Perfect! I'll make sure I give you the credit when my supervisor and coworkers see it.

    You get the gold star for the day!!
    No way! That's not how it works. YOU get to take all the credit. Forget Mark. You've never even heard of the Internet, let alone MrExcel.

    Mention to everyone how it took a long time and a lot of effort, but you finally solved it.

    Mark, nice job.

    Bye,
    Jay




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