Skip to content
REFERENCE

U.FORMULA

Summary

Returns the formula(s) from a referenced cell (or range) instead of its value

Syntax

=U.FORMULA(cell, [all_cells], [as_r1c1], [local])

Parameters

Parameter Required Description
cell Yes The output of U.RANGE_REF that references the cell or range whose formula should be returned. If a multi-cell range is selected, the formula from only the top-left cell in the range is returned by default.
[all_cells] No If set to TRUE and a multi-cell range is selected, then the formula from each cell in the referenced range will be returned as a matrix
[as_R1C1] No If set to TRUE then returned formulas will have Excel's R1C1 formula syntax. By default formulas are returned with A1 syntax
[local] No If set to TRUE then localized versions of Excel method names are returned. By default method names are returned as originally entered

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

=U.FORMULA(D180)

=U.FORMULA(D180:D183,TRUE)

=U.FORMULA(D183,,TRUE)

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.