Results 1 to 6 of 6

IFBLANK formula to output only certain columns and specific texts

Threaded View

  1. #1
    Registered User
    Join Date
    07-25-2011
    Location
    California, USA
    MS-Off Ver
    Excel 2010 PC
    Posts
    19

    IFBLANK formula to output only certain columns and specific texts

    I have a number of columns, all relating to the dimensions of art objects. Unfortunately, each column relates to a different type of measurement:

    N1 Diameter
    P1 Height (centimeters)
    Q1 Height (feet)
    R1 Height (inches)
    S1 Length (centimeters)
    T1 Length (feet)
    U1 Length (inches)
    V1 Width (centimeters)
    W1 Width (feet)
    X1 Width (inches)

    What I want the output to be is a dimensions column that has the values formatted like the following examples:

    287.02 cm (l); 10.795 cm (w)
    10.5 in (h); 10.5 in (l); 10.5 in (w)
    177.79 cm (dia); 78.73 cm (l)

    I was trying to repurpose this other formula to my needs, but I can't quite wrap my head around the way the formula needs to be structured. I just keep getting errors when I try to modify it.

    =IF(ISBLANK(N2),"",", "&N2)&IF(ISBLANK(P2),"",", "&P2)&IF(ISBLANK(Q2),"",", "&Q2)&IF(ISBLANK(R2),"",", "&R2)&IF(ISBLANK(S2),"",", "&S2)&IF(ISBLANK(T2),"",", "&T2)&IF(ISBLANK(U2),"",", "&U2)&IF(ISBLANK(V2),"",", "&V2)&IF(ISBLANK(W2),"",", "&W2)&IF(ISBLANK(X2),"",", "&X2)

    You guys are amazing, so I hope your'e able to help with this. Thanks in advance.

    excel-book-formula.xlsx
    Last edited by Isara; 08-31-2012 at 08:13 PM. Reason: because martindwilson is an Excel god

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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