Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Calculating Variances with Negative Numbers
How do I do this on Smartsheet? I have an Actuals and a Budgets column. I'd like to compare the 2. So for example, if you have a Budget of 100, and an Actual of 70, then the variance would be -30%.
IFERROR((Actual-Target)/Target,0) is all good for positive numbers but I need to ensure it also works for negative numbers.
In Excel, this works using IFERROR((Actual-Target)/ABS(Actual*(Target=0)+Target),0).
How do I get a similar formula to work in Smartsheet?