| T O P I C R E V I E W |
| Neena1695 |
Posted - 12/15/2021 : 2:52:11 PM
Hello Origin Users,
I am trying to set column values of column AB in the attached file using a particular function, but no values are being displayed.
https://my.originlab.com/ftp/forum_and_kbase/Images/p3__ECD.opju
Thank you in advance,
Neena |
| 7 L A T E S T R E P L I E S (Newest First) |
| Neena1695 |
Posted - 12/15/2021 : 6:09:34 PM
Thank you so much, yes that worked! |
| snowli |
Posted - 12/15/2021 : 5:15:25 PM
It's related to how we handle sum differently, maybe some other functions as well.
E.g. if u change AA to G+M+S+Y, if any of the row is missing value, the sum will be missing value.
Try use sqrt(sum(H^2, N^2, T^2, Z^2)) in AB. U will get value.
Thanks, Snow
|
| Neena1695 |
Posted - 12/15/2021 : 4:58:31 PM
Hi Snow,
Interestingly, this wasn't a problem with values in column AA, although I was calculating sum of columns with blank cells. Can you please give your insight on that?
Thank you,
Neena |
| snowli |
Posted - 12/15/2021 : 3:45:23 PM
What should be the calculated?
U may have to put 0 or certain value in the original columns that's used for calculation.
Thanks, Snow |
| Neena1695 |
Posted - 12/15/2021 : 3:34:16 PM
Hi Snow,
Yes I understand that. How to get a value displayed there ignoring blank cells? |
| snowli |
Posted - 12/15/2021 : 3:13:54 PM
The formula in col(AB) contains H, N, T, Z. if any of those values are missing value or none, the result will be missing value as well.
U can try in another workbook.
Fill column A and B with any number.
In Column C's formula, enter sqrt(A^2+B^2).
Then delete any value in column A or B, corresponding row in C will be --.
Thanks, Snow |
| Neena1695 |
Posted - 12/15/2021 : 3:04:24 PM
Re-attaching proper link here.
https://my.originlab.com/ftp/forum_and_kbase/Images/ECD.opju |
|
|
