Error adding two values from a list help me

Mario_Jorge · June 9, 2021, 9:40pm

the right answer would be
552+210=762
it’s not adding up, just joining
552210

Mari · June 15, 2021, 8:00am

Hi, make sure that your values are numbers and not texts, using NUMBER(var1) + NUMBER(var2) will also help!

Mario_Jorge · June 16, 2021, 2:39am

It worked

and the division by the number 60 did not work

Mari · June 16, 2021, 6:33am

Hi, that’s because 1+1/2 = 1+0.5 = 1.5 and (1+1)/2 = 2/2 = 1 Put parentheses around the addition to divide the whole sum

Mario_Jorge · June 16, 2021, 11:58am

it worked, thank you very much

is there a way to limit the number of places after the comma?

Mari · June 16, 2021, 12:19pm

Check out this formula function: FORMAT_LOCALIZED_DECIMAL - Composer

Mario_Jorge · June 16, 2021, 6:16pm

the list values are out of order
I don’t understand why

Mario_Jorge · June 16, 2021, 6:30pm

Mari · June 18, 2021, 7:19am

Hi, the formatting turns it into a text so you cannot divide it anymore. If you want to keep it as a number, FLOOR() rounds it to the nearest integer