% as Negative
Options
Tony Barthelemy
✭✭✭✭
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.
Tags:
Comments
-
Hi Kam,
=IFERROR(IF(AC1 / [Project Budget]1 >1, 1 - AC1 / [Project Budget]1, AC1 / [Project Budget]1),"")
This should do what you're looking for. I threw an IFERROR in there so you didn't get an error result if the values were blank.
Kind regards,
Chris McKay
-
Thanks!
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!