Nested IF statements not functioning

Platform discussions
, , ,
1

I am using nested IF statements tied to a checkbox to derive the value to be used in a sum for pipeline forecasting. In this case, the item is either being acquired or resold.

Here is the formula.

IF({Incl in Pipeline?}, IF({Net Cash Proceeds} = “”, -1*{Total Cash to Acq}, {Net Cash Proceeds}),“”)

The logic appears to work EXCEPT when the box is checked and the Net Cash Proceeds is null. In that scenario, it delivers a value of “0”. I can’t figure out what I’m doing wrong.

2

Hello @zapatero
You’re running into how monday handles empty Numbers fields. They’re often treated as 0, not truly blank, so this check:

{Net Cash Proceeds} = “”

may not behave as expected. That’s why you’re getting 0 instead of triggering the negative acquisition value.

Try using ISBLANK instead:

IF(
  {Incl in Pipeline?},
  IF(
    ISBLANK({Net Cash Proceeds}),
    -1 * {Total Cash to Acq},
    {Net Cash Proceeds}
  ),
  ""
)

If you also want 0 to be treated like blank, use:

OR(ISBLANK({Net Cash Proceeds}), {Net Cash Proceeds} = 0)

If you’d like hands-on help or want us to walk through this live, you can book a 1:1 paid 60-minute strategy session with our team here:
:backhand_index_pointing_right: Calendly

3

Hi @zapatero,

Welcome to the community!

The reason you’re seeing 0 is that monday sometimes evaluates an empty Numbers column as 0, so checking = “” doesn’t always behave as expected.

If 0 is a legitimate value, meaning you only want the negative acquisition when the field is truly blank.

Use this formula:

IF(
{Incl in Pipeline?},
IF(
ISBLANK({Net Cash Proceeds}),
-1 * {Total Cash to Acq},
{Net Cash Proceeds}
),
“”
)

This will:

  • Return Net Cash Proceeds (including 0 if entered intentionally)
  • Return –1 × Total Cash to Acq only when Net Cash Proceeds is blank
  • Return blank if the checkbox is unchecked

If 0 should ALSO trigger the negative acquisition, meaning blank or zero should use Total Cash to Acq.

Use this version instead:

IF(
{Incl in Pipeline?},
IF(
OR(ISBLANK({Net Cash Proceeds}), {Net Cash Proceeds} = 0),
-1 * {Total Cash to Acq},
{Net Cash Proceeds}
),
“”
)

Hope this help!!