Dynamically reference table cell with other cell value

Copper Contributor

I'm trying to find if there is a way to dynamically generate the following cell statement with the value for "R" and "L" based on the value of another cell on that table row.

 

 

=([@R2]/([@[M_Low]]*[@L2])*365

 

 

In Cell "R_Val" I have the number for "R" and in "L_Val" I have the value for "L".

 

I've tried to search for a solution, but couldn't find one specific to my case.

 

0 Replies