If Not Blank Formula Executing Incorrectly

Kaleb

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)

Kaleb

I Found The Issue with The Parenthesis:

Updated Formula:

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

DKazatsky

@Kaleb

See what happens if you remove the ")" after EV@row

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

Hope this helps,

Dave

Kaleb

https://community.smartsheet.com/discussion/comment/362079#Comment_362079

That Results in The Incorrect Calculation. However, I Figured it Out.

Update Formula:

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

Thanks