How to calculate percentage differences between rows referenced to a cell in another column
Hello all, I have the following table. For each subject, I would like to calculate the % difference of the d1, d2, d3 and d4 values in the Value column relative to the screen value. The formula is ((d1-screen)/screen)*100, repeating for the d2 through d4 values for subject 1. Then when the subject number changes, the screen value for subject 2 is referenced for the calculation using subject 2...
rleeper
hemi_timken_com
tony_cooper1
jeff_kiesner
Steven_Moore
sophiaw
saitcopuroglu