troubleshooting Question

Newbie: formula translation

Avatar of Fordraiders
FordraidersFlag for United States of America asked on
Lotus IBM
1 Comment1 Solution292 ViewsLast Modified:
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






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)
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros