% as Negative

Tony Barthelemy
Tony Barthelemy ✭✭✭✭
edited 12/09/19 in Formulas and Functions

How do you structure your formula calculate negative if it is over 100%

For example, I am at 144% which is over budget

Current Formula =AC1 / [Project Budget]1

Results 144%, I would like it to calculate -44% once I am over budget.





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!