Percent (%) Sign Usage

I realize this may be a dumb question, but I don't understand how the % sign works in a formula. There is one article that discusses it, but it provides no explanation or context. Thanks for any help.

-newbie

1 Like

Hi @Allen , nice to see you here again! :slight_smile: :honeybee:

Percentage symbols in formulas serve as parameter references. When you break down the structure of formulas, there is often a condition and parameters for that condition to be met.

For an example, here's a FINDROW formula:
=FINDROW(Contacts, "Contacts[Name]=%", "Allen")

The structure is FINDROW(Table, Condition, Parameters). The % is a reference to the parameter "Allen", and it will return the first value in the Contacts table that matches that condition.

Another example and a description of it is also in this article under the "Conditions and text values" section: Formula Syntax.

Let me know if that helps clarify, or if you have any other questions around this. :honey_pot:

1 Like