There are so many examples where this could be useful that I don’t even know where to start.
- Any field where the user can override an automatic calculation by entering a value manually
- Any field that should automatically calculate if the user does not enter a value
Here’s one specific example. A sheet has multiple fields for the price of a single product. Each field represents a different currency (USD, CAD, EUR, etc). I don’t know which currency the user will choose to enter, but I want the other currency fields to immediately calculate and show the equivalent currency amounts. Without an “UPDATEIFEMPTY” function to use, these calculations are considered circular references and are not allowed in Ragic.