| T O P I C R E V I E W |
| Adamantan |
Posted - 06/02/2021 : 05:59:05 AM
Hey,
I have raw data in column B of worksheet AbsorbanceRaw. Now i calculate a mean value of a range of rows and store it in userparameter mean_600
in a second worksheet I tried to subtract that mean_600 value from every single Value of AbsorbanceRaw!B as follows:
F(x)=AbsorbanceRaw!B-col(B)[mean_600]$
this fails ;(
However, F(x)=AbsorbanceRaw!B works as well as col(B)[mean_600]$ when written in a random cell of worksheet corrbl.
Any ideas why F(x)=AbsorbanceRaw!B-col(B)[mean_600]$ fails?
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2020b (9.7.5.184 )
Operating System: Win2000 |
| 2 L A T E S T R E P L I E S (Newest First) |
| Adamantan |
Posted - 06/02/2021 : 09:23:43 AM
Thanks very much! |
| Shirley_GZ |
Posted - 06/02/2021 : 06:21:07 AM
Hi Adamantan,
please correct the function as below:
F(x)=AbsorbanceRaw!B-%(B[mean_600]$)
Thanks,
Shirley
OriginLab
Originlab Technical Service Team |
|
|
