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
Bookmarks