Results 1 to 9 of 9

multiple column if statement

Threaded View

  1. #1
    Registered User
    Join Date
    10-10-2014
    Location
    seattle wa
    MS-Off Ver
    2007
    Posts
    63

    multiple column if statement

    I am very new at doing formula in excel. How do I do a if statement that looks at multiple columns.


    Example:
    A B C
    Row1 1982
    Row2 1974
    Row 3 1982
    Row 4 1974

    I need a if statement first to read Column A , if there is year in column A then give me the year. If there is not year in column A then look at column B, if there is year in B then give that year, If no year in column B then look at C and then give me the year in C.

    Thank you
    Last edited by gill123; 07-06-2015 at 01:44 PM. Reason: example not showing up right

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMIFS statement needed to pull multiple data from the same column
    By onetoncrewcab in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2014, 08:27 PM
  2. Replies: 7
    Last Post: 08-11-2014, 12:05 PM
  3. [SOLVED] If statement that will look among multiple criteria and generate a statement
    By liz5818 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-01-2013, 04:12 PM
  4. IF statement using multiple variables to give multiple outcomes
    By stujordan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-06-2009, 06:46 AM
  5. Replies: 1
    Last Post: 04-10-2008, 11:47 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