+ Reply to Thread
Results 1 to 6 of 6

If Formula with drop down and 2 different cells

  1. 11-23-2020, 11:47 AM #1
    Waldo316
    Waldo316 is offline
    Registered User
    Join Date
    11-17-2020
    Location
    Milton Keynes
    MS-Off Ver
    365
    Posts
    15

    If Formula with drop down and 2 different cells

    Hello again,

    i hope everyone had a great weekend I am back for some much needed help, so far everybody who has helped me has been brilliant.

    What i would like to achieve on the attached spreadsheet is

    If Column BQ = FIXED then Column BR(Cell BR9) = Column BA (Cell BA9) But if Column BQ = Adjustable then Column BV(Cell BV9) = Column BA (Cell BA9)-2, then if BQ is blank no data to show. in either column BQ or BV

    That means that currently they should read 562 and 560 respectively in the appropriate column (fixed shelves or Shelves)

    Tank you in advance for the help.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-24-2020, 01:48 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: If Formula with drop down and 2 different cells

    That means that currently they should read 562 and 560 respectively in the appropriate column (fixed shelves or Shelves)
    I dont see how that is possible?
    If BA9=FIXED, then BV9 cannot show anything, because it only triggers with AJUSTABLE? (Each shows the correct values IF the relevant DD is selected though)

    The formulas I used are...
    BR9=IF(BQ9="Fixed",BA9,"")
    BV9=IF(BQ9="adjustable",BA9-2,"")

    However, you didnt say what to show in BV9 if BA = FIXED (and vice versa) so I just assumed you wanted it to show nothing - same as if it were empty.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 11-25-2020, 05:40 AM #3
    Waldo316
    Waldo316 is offline
    Registered User
    Join Date
    11-17-2020
    Location
    Milton Keynes
    MS-Off Ver
    365
    Posts
    15

    Re: If Formula with drop down and 2 different cells

    Quote Originally Posted by FDibbins View Post
    I dont see how that is possible?
    If BA9=FIXED, then BV9 cannot show anything, because it only triggers with AJUSTABLE? (Each shows the correct values IF the relevant DD is selected though)

    The formulas I used are...
    BR9=IF(BQ9="Fixed",BA9,"")
    BV9=IF(BQ9="adjustable",BA9-2,"")

    However, you didnt say what to show in BV9 if BA = FIXED (and vice versa) so I just assumed you wanted it to show nothing - same as if it were empty.
    HI FDibbins,

    Sorry i have been caught up with some other work, so i am just coming back to this.

    I may have got a bit muddled up with trying to explain what i wanted to show, i shall try again.

    BA9 will show a number previously generated by another formula, in this case we have 562. so if BQ9 = FIXED i want BR9 to display 562. While fixed is selected nothing would show in the shelves column BV9

    If ADJUSTABLE i would like BV9 to show the 562 in BA9 but with a minus 2 so we would see 560 and again nothing referenced in the Fixed shelf column. (this is because in our carcasses we either have fixed or adjustable shelving never both)

    Then if the drop down isn't selected at all leaving it blank i don't want any information to show in the boxes. this will stop me having loads of -2 showing up on any of the unused columns

    Does this make a little more sense? i look forward to your response.

    Thank you
    Last edited by Waldo316; 11-25-2020 at 05:42 AM.
    Reply With QuoteRegister To Reply
  4. 11-26-2020, 01:58 AM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: If Formula with drop down and 2 different cells

    That is exactly what my suggested formulas do. Did you try them at all?
    Reply With QuoteRegister To Reply
  5. 11-26-2020, 08:26 AM #5
    Waldo316
    Waldo316 is offline
    Registered User
    Join Date
    11-17-2020
    Location
    Milton Keynes
    MS-Off Ver
    365
    Posts
    15

    Re: If Formula with drop down and 2 different cells

    FDibbins Sorry thy do exactly what i want, i misread your reply thinking you meant it was somehow broken so that's on me. I must admit i thought that formula would be a lot more complex.

    Appropriate it so much

    did you see my reply on this thread? I hope i have explained it better https://www.excelforum.com/excel-gen...ml#post5428517

    I will leave some feedback and marked this as solved
    Reply With QuoteRegister To Reply
  6. 11-27-2020, 01:42 AM #6
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: If Formula with drop down and 2 different cells

    Thanks for the feedback

    Also, I have now replied to your other post - sorry, it got lost
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to fill cells based on a drop down list
    By ljenkins73 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-08-2020, 05:52 PM
  2. Drop-down list that changes specifics cells formula
    By adambe in forum Excel General
    Replies: 2
    Last Post: 10-20-2015, 08:50 AM
  3. Drop down list value decides the formula for another related cells ?
    By andyzz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-15-2014, 01:57 PM
  4. Formula for correlating cells based on a drop down
    By PittyPotts in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-20-2014, 01:29 PM
  5. Formula: Drop Down List -> Choose Option Finds Cells & Replace Cells with Cells
    By g00glethis1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-14-2010, 01:10 PM
  6. Locking Formula Cells only-SOLVER AND DROP DOWN MENU
    By gtg430i in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2008, 03:32 PM
  7. drop down list/box that has formula built in for other cells
    By Terry in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2005, 09:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1