Skip to main content
Question

Define a cell as active despite having a zero value

  • May 21, 2026
  • 1 reply
  • 8 views

ChrisAHeathcote
Author
Forum|alt.badge.img

Hi 

Is it possible to define a cell as in use/active even when the result is zero?

I have a filter that distinguishes active cells so can I combine this with the formula so it returns a zero?

Thanks,

1 reply

Min Li
Master Helper
Forum|alt.badge.img+14
  • Master Helper
  • May 21, 2026

Are you looking from something like ifdefined function? Here the the article for your reference.