+ Reply to Thread
Results 1 to 5 of 5

Combining multiple IF statements

  1. #1
    Registered User
    Join Date
    12-02-2012
    Location
    Harrow
    MS-Off Ver
    Excel 2003
    Posts
    73

    Red face Combining multiple IF statements

    I have tried to combine the following If statements

    =IF(F7="Office",C5)
    IF(f7="Retail",D5,)
    IF(F7="Residential",E5)

    But rather then give me values it gives me False or True, how would I combine these so that It gives me the corresponding values (C5:E5)

    Many thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Combining multiple IF statements

    =IF(F7="Office",C5,IF(F7="Retail",D5,IF(F7="Residential",E5,"Empty")))
    Elegant Simplicity............. Not Always

  3. #3
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Combining multiple IF statements

    Here!


    Put this formula in Cell G7 and drag it down.

    =HLOOKUP(F7,$C$4:$E$5,2,0)

    File attached too..

    Deep
    Attached Files Attached Files
    Cheers!
    Deep Dave

  4. #4
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Combining multiple IF statements

    With the layout you provided, in G7 try:

    Please Login or Register  to view this content.
    Autofill down.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  5. #5
    Registered User
    Join Date
    12-02-2012
    Location
    Harrow
    MS-Off Ver
    Excel 2003
    Posts
    73

    Re: Combining multiple IF statements

    Thanks a lot

    Just one question the layout would be different in my actual sheet - would i need to change the #2, and if so how would i do this.

    Thanks!

+ 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. Replies: 3
    Last Post: 07-25-2013, 08:25 AM
  2. [SOLVED] Combining multiple IF THEN statements
    By ktbb0312 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-03-2013, 02:04 AM
  3. [SOLVED] Combining together multiple IF statements
    By jupitar in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-20-2012, 08:51 PM
  4. Combining Multiple IF Statements
    By prefcomm in forum Excel General
    Replies: 2
    Last Post: 11-11-2009, 11:35 PM
  5. Combining IF and multiple SUMIF statements, if A>0 & B is between
    By Lee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-03-2005, 03: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1