Results 1 to 4 of 4

Use IF formula based on choice in another cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    639

    Use IF formula based on choice in another cell

    I have a drop down choice in (D7) the Choices are "A/B - L/R" OR "N/S - E/W"
    In (C15) I have the formula

    =IF(B15>0,"Above","Below")

    I need to change it to look @ cell (D7) and if they have chosen "A/B - L/R" then the existing formula is correct but if they have selected "N/S - E/W" then I need to use

    =IF(B15>0,"North","South")

    Thanks for your help
    Attached Files Attached Files
    Last edited by bdouglas1011; 12-05-2019 at 08:56 AM. Reason: ADDED SAMPLE SHEET

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 04-25-2019, 08:15 PM
  2. [SOLVED] Change cell value based off list choice
    By Broncswon in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-21-2019, 05:09 PM
  3. How to lock a cell based on a choice in a dropdown box?
    By g0dmenuelz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2019, 04:28 PM
  4. Change Formula based on value of drop drown choice
    By snuffnchess in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-13-2015, 11:33 AM
  5. [SOLVED] Changing cell value based on drop down box choice
    By CDNGirl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-26-2015, 12:05 PM
  6. I need a formula that fills one cell based upon a choice made in another cell
    By rayrudolph in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-29-2013, 06:35 PM
  7. Replies: 2
    Last Post: 07-10-2012, 04:37 PM

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