Results 1 to 5 of 5

Combining multiple IF statements

Threaded View

  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

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. [SOLVED] 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