How to only edit a cell if it is negative

Louis.Smith ✭✭✭

07/20/23 edited 07/20/23 in Formulas and Functions

I have a formula that sometimes will pull a negative number.

What would the formula be to multiply by -1 if negative?

0 · Share on FacebookShare on Twitter

Best Answer

• 

  Carson Penticuff Community Champion

  07/20/23 Answer ✓

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

  1 · Share on FacebookShare on Twitter

Answers

• 

  Carson Penticuff Community Champion

  07/20/23 Answer ✓

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

  1 · Share on FacebookShare on Twitter
• 

  Louis.Smith ✭✭✭

  07/20/23

  Thank you

  0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list