Results 1 to 7 of 7

Based on data validation list value Formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-15-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    149

    Based on data validation list value Formula

    I have a data validation list on B3. My lists are 1st Qt., 2nd Qt., 3rd Qt., 4th Qt., 5th Qt., 6th Qt. in B3
    and my answer is in B8


    B8=IF (B3=”1st Qt.”, “2nd Qt.”, “”)
    B8=IF (B3=”2nd Qt.”, “3nd Qt.”, “”)
    B8=IF (B3=”3rd Qt.”, “4th Qt.”, “”)
    B8=IF (B3=”4th Qt.”, “5th Qt.”, “”)
    B8=IF (B3=”5th Qt.”, “6th Qt.”, “”)

    I would like to get a one formula to B8. Maybe OR, AND

    Please help.......

    Thanks!
    Last edited by raw_geek; 12-17-2012 at 07:11 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1