Using AND in worksheet

[Mike Williams]

Hi Trying to make a cell that takes data from more than one record and splice them together.

 

Example 

'Multicable VW'.'Part 1' = 1m

'Multicable VW'.'Part 2' = 3m

 

Cell 'Multicable VW'.'Part 1' & 'Multicable VW'.'Part 2' = 1m3m

 

What am i doing wrong

?

[Pat Stanford]

=Concat('Multicable VW'.'Part 1', 'Multicable VW'.'Part 2')

 

Should generate =  1m3m

[Sam Jones]

I'm unclear as to what you want the resulting cell to be.

 

[Mike Williams]

@Sam Jones I was attempting to make a string of data from inputs from vw into one cell.  

 

In the example i was trying to put the different parts in a cable into the spreadsheet in one cell.  This is done for you in the Multi-cable label format but not in any other record format associated with cable types (as far as i can see).  I also want to use if for other pieces.  I was missing. the function concat().

 

Is there a cleaner way of doing this.

=CONCAT((IF(('Feeder Cable VW'.'Part 1'>0), ('Feeder Cable VW'.'Part 1'), '')), (IF(('Feeder Cable VW'.'Part 1'>0), ('m'), '')), (IF(('Feeder Cable VW'.'Part 2'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 2'>0), ('Feeder Cable VW'.'Part 2'), '')), (IF(('Feeder Cable VW'.'Part 2'>0), 'm', '')), (IF(('Feeder Cable VW'.'Part 3'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 3'>0), ('Feeder Cable VW'.'Part 3'), '')), (IF(('Feeder Cable VW'.'Part 3'>0), 'm', '')), (IF(('Feeder Cable VW'.'Part 4'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 4'>0), ('Feeder Cable VW'.'Part 4'), '')), (IF(('Feeder Cable VW'.'Part 4'>0), 'm', '')), (IF(('Feeder Cable VW'.'Part 5'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 5'>0), ('Feeder Cable VW'.'Part 5'), '')), (IF(('Feeder Cable VW'.'Part 5'>0), 'm', '')), (IF(('Feeder Cable VW'.'Part 6'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 6'>0), ('Feeder Cable VW'.'Part 6'), '')), (IF(('Feeder Cable VW'.'Part 6'>0), 'm', '')), (IF(('Feeder Cable VW'.'Part 7'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 7'>0), ('Feeder Cable VW'.'Part 7'), '')), (IF(('Feeder Cable VW'.'Part 7'>0), 'm', '')), (IF(('Feeder Cable VW'.'Part 8'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 8'>0), ('Feeder Cable VW'.'Part 8'), '')), (IF(('Feeder Cable VW'.'Part 8'>0), 'm', '')), (IF(('Feeder Cable VW'.'Part 9'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 9'>0), ('Feeder Cable VW'.'Part 9'), '')), (IF(('Feeder Cable VW'.'Part 9'>0), 'm', '')))

(IF(('Feeder Cable VW'.'Part 2'>0), '+', '')), (IF(('Feeder Cable VW'.'Part 2'>0), ('Feeder Cable VW'.'Part 2'), '')), (IF(('Feeder Cable VW'.'Part 2'>0), 'm', '')),

which is the 3 if statements added for each of the 9 cable parts.

Goal is to create a cell that looks like this

 

5m+7m+8m if a value exists in the cell.

 

m

 

[Sam Jones]

Unfortunately, no.