the right answer would be
552+210=762
it’s not adding up, just joining
552210
Hi, make sure that your values are numbers and not texts, using NUMBER(var1) + NUMBER(var2)
will also help!
1 Like
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
1 Like
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