How to only edit a cell if it is negative
Options
Louis.Smith
✭✭
I have a formula that sometimes will pull a negative number.
What would the formula be to multiply by 1 if negative?
Best Answer

You can just wrap the entire formula you are using in ABS() to return the absolute value.
Answers

You can just wrap the entire formula you are using in ABS() to return the absolute value.

Thank you
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!