| Author |
 Topic  |
|
|
Neena1695
Canada
117 Posts |
|
|
Neena1695
Canada
117 Posts |
|
|
snowli
USA
1386 Posts |
 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
Canada
117 Posts |
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
USA
1386 Posts |
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
Canada
117 Posts |
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
USA
1386 Posts |
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
Canada
117 Posts |
Posted - 12/15/2021 : 6:09:34 PM
|
| Thank you so much, yes that worked! |
|
|
| |
Topic |
|
No values displayed with column function