How do I sum up the last two characters of a cell?

I have a column where the last two characters are a number. If I do


Value(right(cell,2)

I get the correct number. I can also add Value(right(cell1,2) +Value(right(cell2,2)


But I would like to calculate a cell to be the sum of the right two characters in a column in another sheet. How do I do that?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!