Newbie:  formula translation

LN DOMINO 5

R1 TO R10 refer to fields in a table grid.
 r1e to r10e   are a column in the table

the rows are dependent on the number  of employees I enter.


I need to know what exactly this formula is telling me...

What I'am hoping is:
if  @Text(R1E)  has data in the cell...give me the value  associated to the  name in row 1
if  @Text(R2E);  has data in the cell...give me the value  associated to the  name in row 2

??


Thanks
fordraiders





Start Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:

tmpR1E := @Text(R1E);
tmpR2E := @Text(R2E);
tmpR3E := @Text(R3E);
tmpR4E := @Text(R4E);
tmpR5E := @Text(R5E);
tmpR6E := @Text(R6E);
tmpR7E := @Text(R7E);
tmpR8E := @Text(R8E);
tmpR9E := @Text(R9E);
tmpR10E := @Text(R10E);
 
@Trim(tmpR1E : tmpR2E : tmpR3E : tmpR4E : tmpR5E : tmpR6E : tmpR7E : tmpR8E : tmpR9E : tmpR10E)