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

Returning 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 that you never import to or include on sheets so that it is always blank.

For example, if my empty custom account is called "blank" I can write 

If(a=b, c, ACCT.blank)

and return a blank value.

formulablank.png

  • Was this article helpful?