+ Reply to Thread
Results 1 to 6 of 6

How can i use nested if statements in combination with dropdowns

  1. #1
    Registered User
    Join Date
    02-15-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    15

    How can i use nested if statements in combination with dropdowns

    Hello everyone I've encountered a problem that I cannot figure out. How can I correct the problem I'm having. What I'm trying to achieve is a calculation for cell H10 using nested IF statements. If C10 & A2 match and there is a price in cell C2 then the price will show in H10, but if there is no price in C2 then H10 will show the value calculated from G10*45*24. So far this is working but my problem is if I select a different selection available in C10 and match it with lets say A3 then nothing happens. Can anyone guide me through this problem. Thanks. I have attached a working test file.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: How can i use nested if statements in combination with dropdowns

    Your nesting doesn't quite fit what you describe. Try something more like this in H10:

    =IF(AND($C2>0,$C10=$A2),$C2,$G10*45*24)

    Edit: JohnTopley's post below should prove more versatile
    Last edited by CAntosh; 03-28-2016 at 03:57 PM.

  3. #3
    Forum Contributor
    Join Date
    01-04-2013
    Location
    Tampa, Florida
    MS-Off Ver
    Excel 2013
    Posts
    142

    Re: How can i use nested if statements in combination with dropdowns

    Nevermind. My solution didn't work properly
    Last edited by mo4391; 03-28-2016 at 03:50 PM.

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,998

    Re: How can i use nested if statements in combination with dropdowns

    Try in H10

    =IF(VLOOKUP($C10,$A$2:$C$4,3,0)=0,G10*45*24,VLOOKUP($C10,$A$2:$C$4,3,0))

  5. #5
    Registered User
    Join Date
    02-15-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: How can i use nested if statements in combination with dropdowns

    Thank you JohnTopley for your help on this. I have tried your formula and it appears to work great. =IF(VLOOKUP($C10,$A$2:$C$4,3,0)=0,G10*45*24,VLOOKUP($C10,$A$2:$C$4,3,0))

  6. #6
    Registered User
    Join Date
    02-15-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: How can i use nested if statements in combination with dropdowns

    Thank you JohnTopley for your help on this. I have tried your formula and it appears to work great. =IF(VLOOKUP($C10,$A$2:$C$4,3,0)=0,G10*45*24,VLOOKUP($C10,$A$2:$C$4,3,0))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Nested if statements containing multiple and statements
    By John M. in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-22-2014, 11:48 PM
  2. Dependent Nested Dropdowns
    By ACFHogan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-05-2013, 03:04 AM
  3. questions with if statements and nested if statements
    By Pat Excel in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-03-2013, 01:41 PM
  4. combination of multiple statements into an IF statement
    By Pat Excel in forum Excel General
    Replies: 1
    Last Post: 01-31-2013, 01:32 PM
  5. Multiple nested IF statements and AND statements
    By TonyGetz in forum Excel General
    Replies: 2
    Last Post: 12-14-2010, 03:07 AM
  6. Nested If statements / logic statements
    By Brainless_09 in forum Excel General
    Replies: 3
    Last Post: 06-17-2009, 02:59 PM
  7. Replies: 12
    Last Post: 05-15-2009, 08:38 AM

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