Results 1 to 9 of 9

Nested IFs

Threaded View

  1. #1
    Registered User
    Join Date
    12-14-2009
    Location
    PA
    MS-Off Ver
    Excel 2007
    Posts
    9

    Nested IFs

    I would like to have excel look at column b and return the values in column a if there is a value in column b.

    Here is what started with, but I am very new at excel.

    =IF(ISTEXT(Schedule!B12),Schedule!A12,(IF(ISTEXT(Schedule!B16),Schedule!A16)))

    I am trying to do this for 8 rows and only want it to populate if there is a value in column B

    I can get it to populate with blanks, but I would like it only to populate when there is a value.

    Thanks in advance.
    Last edited by padadof2; 01-06-2010 at 02:40 PM.

Thread Information

Users Browsing this Thread

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

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