Results 1 to 8 of 8

If any of these cells have text in them put a comma, if there is no text then a comma

Threaded View

  1. #1
    Registered User
    Join Date
    11-27-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    66

    Question If any of these cells have text in them put a comma, if there is no text then a comma

    I have an extremely long formula and I need to list the family members like so.

    Person lives with PARENT 1 CELL (PARENT1 NAME CELL, PARENT1 AGE CELL)

    Then it gets trickier because there are 4 more sets (relation, name, age) to account for other family members. If ANY of these cells have information in them there should be a comma afterwards [i.e., (PARENT1 NAME CELL, PARENT1 AGE CELL), ]. If NONE of these cells have any information in them there should be a period.

    &IF('Qualtrics Output'!BD3, 'Qualtrics Output'!BG3, 'Qualtrics Output'!BJ3, 'Qualtrics Output'!BM3="",”.”,”,”) is not how to do it...
    All the referenced cells are names btw.
    Last edited by sharpmel; 12-06-2012 at 01:43 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