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
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
Hi @Allen , nice to see you here again!
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.