Sum of the results of the if function in last row

in the last line the sum of the results from the following formula not appears:

Blockquote ifs({Alter}>18, 1, {Alter}>12, 0.6 ,{Alter}>0, 0.3)
or
Blockquote ifs({Alter}>18, “1”, {Alter}>12, “0,6” ,{Alter}>0, “0,3”)

Hi, you need to describe the problem with a little bit more details so that people here can understand you.

Here is a screenshot i hope this clears up the confusion

Thanks. It’s crystal clear now.

I think the problem here is that, the formula result of “1” is considered as text instead of number. Let’s see what we can do and I’ll come back to you as soon as possible.

Is there a way to copy the values into a new column and convert them as a number?
As a temporary solution

Hi, thanks for the patience. We’ve solved this problem in 2.3.3

And the good news is, 2.3.3 will be released very soon!

perfect. thanks for the fast solution

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.