How to calculate the difference between two values and display the result with a + or  sign
Hi community! How can I calculate the difference between two values and display the result with a positive or negative sign depending on whether the difference is upward or downward?
For example, if I have two values: 5 and 2. I need the following result: 7.
And if I have: 5 and 2. I need the following result: 3.
Thank you so much!!
Answers

I believe this will take care of it. Just subtract your first number from the second.
=[column 2]@row  [column 1]@row
2  5 = 7
2  (5) = 3
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!