# Replace Null Results with a "0"

I need to use the results of a calculation in one column for a subsequent calculation; however, some results are null. How can I replace those null/blank results with a “0”? Is this possible?

Hey Stephen!

Charlotte here for the monday team! Happy to help with this!

To confirm, you are looking for the calculation from a formula column to show a 0 if the result is null, right? Are you using an “IF” formula function?

If so, you can add a comma then “0” at the end of the formula to mean “if the answer is not __, then return “0” instead of a blank”.

Let us know if this helps or if you have any further questions! You can also send the monday.com page a DM on any of our social media platforms and we can help you there!

You can use the IF function to do this. Just wrap your calculation in an IF statement like this:

=IF(ISBLANK(A1), 0, your_formula_here)

This formula checks if cell A1 is blank, and if it is, it returns 0; otherwise, it calculates your formula.

Thank you, both, for your replies. Neither formula does what I’m looking for, however. To be more specific, I have a column where I have the formula:

WORKDAYS({Hold Start}, {Hold Stop})

What I am trying to do is have that formula return a “0” is the result is null/blank. I’m sorry if this is a basic question. This is all very new to me.

Steve

I have a column where I have the formula:

WORKDAYS({Hold Start}, {Hold Stop})

What I am trying to do is have that formula return a “0” is the result is null/blank. I’m sorry if this is a basic question. This is all very new to me.

``````IF(WORKDAYS({Hold Start}, {Hold Stop})="",0,WORKDAYS({Hold Start}, {Hold Stop}))