Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Returning a Blank Value in a Formula

This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.

Question

How can I return a blank value in a formula?

Answer

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)

formulablank.png

  • Was this article helpful?