If Not Blank Formula Executing Incorrectly


Smartsheet Community:

Take a Look at my Formula Below. The Formula is Returning 0, Even Though EV is Blank. Do I Have a Parenthesis in The Wrong Position?

Current Formula:

=IF(NOT(ISBLANK(EV@row)), $[Project Budget]$1 - EV@row) / ($[Project Budget]$1 - AC@row)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!