Hi Guys,
[@[DB]]+[@[Baseline]]+[@[2 Baseline]] results in #Value! because the [Baseline] cells are empty. DB has value.
Why does it get the #value!? I expect for example 50+empty+empty = 50.
Is it possible to change some settings that it sees the empty cells as zero?
Thx for any help in advance.
[@[DB]]+[@[Baseline]]+[@[2 Baseline]] results in #Value! because the [Baseline] cells are empty. DB has value.
Why does it get the #value!? I expect for example 50+empty+empty = 50.
Is it possible to change some settings that it sees the empty cells as zero?
Thx for any help in advance.