Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following chart, I add expression
=(DELTA1 + DELTA2 + DELTA3 )
It's works fine if DELTA3 is not null.
The result of the first line should give:
14 + 0 + '-' = 14
Someone have an idea?
DELTA1 | DELTA2 | DELTA3 | DELTA1+DELTA2+DELTA3 |
14 | 0 | - | - |
14 | 0 | - | - |
6 | 0 | - | - |
6 | 0 | - | - |
8 | 0 | - | - |
1 | 0 | - | - |
9 | 0 | - | - |
9 | 0 | - | - |
11 | 0 | - | - |
9 | 0 | - | - |
6 | 0 | - | - |
6 | 0 | - | - |
6 | 0 | - | - |
6 | 0 | - | - |
6 | 0 | - | - |
6 | 0 | - | - |
6 | 0 | - | - |
6 | 0 | - | - |
33 | 0 | - | - |
41 | 0 | 0 | 41 |
13 | 0 | - | - |
Hi,
try you this:
(DELTA1 + DELTA2 + if(isnull(DELTA3),0,DELTA3) )
Try like:
=RangeSum(DELTA1, DELTA2, DELTA3)
Hi,
(DELTA1 + DELTA2 + alt(DELTA3, 0))
Best,
Aurélien