If Not Blank Formula Executing Incorrectly

Kaleb · 02/13/23

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 · 02/13/23

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 · 02/13/23

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 · 02/13/23

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

Answers