This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.
How can I return a blank value in a formula?
Formulas can return hard coded numeric values, or the values contained in an account. If you would like a formula to return a blank value, you can do so by creating a custom account (ACCT.Blank) that you never import to or include on sheets so that it is always blank.
For example, my empty custom account is called "Blank" so I can write the formula as:
If(a=b, c, ACCT.Blank)