Results 1 to 3 of 3

Thread: Help with If/Then Statement - If Column B = "X" Then enter "Y" in Col C

  1. #1

    Help with If/Then Statement - If Column B = "X" Then enter "Y" in Col C



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello - - Excel novice here.

    I am creating a scoring spreadsheet for a dive meet. In a specific column, I have a drop down box with the list of possible dives someone could do. Each dive has a corresponding DD (degree of difficulty - for example, 104D - Front Dive Pike has a DD = 1.4). As I am entering a person's dive(s) on separate rows of the spreadsheet - - I would like the Degree of Difficulty column to automatically populate with the correct DD based on the name of the dive entered from the previous column (and included in a drop down box). Any suggestions how to accomplish this? Thank you in advance for your help.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016


  3. #3
    Acolyte caabyyc's Avatar
    Join Date
    Dec 2014
    Location
    Burnaby/Calgary
    Posts
    39
    Articles
    0
    Excel Version
    2016
    one example is better than thousand of word .

    [QUOTE=tomskoog;19232]Hello

Posting Permissions

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