Skip to content
REFERENCE

U.CURRENT_VALS

Summary

Returns the current values of the calling range

Syntax

=U.CURRENT_VALS([keep_zeros])

Parameters

Parameter Required Description
[keep_zeros] No If set to TRUE then zeros returned by Excel will not be replaced with blank strings. If set to a range of values, the range will be used to determine when to replace zeros with blank strings

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=IF(B59>3,B59:B61*2,U.CURRENT_VALS())

=IF(B75>3,U.DO(B75:B77),U.CURRENT_VALS())

=IF(B85>3,U.DO(B85:B87),U.CURRENT_VALS(B85:B87))

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.