Nested IF statements not working

Platform discussions Special workflows & use cases
,
1

I have built the following formula that checks a checkbox and, if checked, checks another field to see if that is null. If the field is null, then it pulls a [negative] value from another field. If not null, then it pulls the value from the first field.

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

All of the logic seems to be working except for when it’s supposed to pull the -{Total Cash to Acq} number. When the logic runs into this scenario, the formula returns a value of “0”. Any ideas?

2

Hello @zapatero
This is likely happening because Numbers columns in monday.com are not truly blank. If no value is entered, they are treated as 0. So this check:

{Net Cash Proceeds} = ""

will not work as expected.

Try checking for 0 instead:

IF(
  {Incl in Pipeline?},
  IF(
    {Net Cash Proceeds} = 0,
    -{Total Cash to Acq},
    {Net Cash Proceeds}
  ),
  ""
)

If needed, you can also use ISBLANK depending on your column type.

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