Formualizer Docs
ReferenceFunctionsText Functions

EXACT

Compares two text values for exact equality.

Summary

Compares two text values for exact equality.

Remarks

  • Comparison is case-sensitive.
  • No wildcard semantics are applied.
  • Non-text values are converted to text before comparison.
  • Errors in either argument are propagated.

Examples

Exact same text
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
true
Case difference is not equal
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
false

FAQ

Does EXACT perform case-sensitive comparison?

Yes. EXACT compares the resulting text values with exact case and character equality.

Runtime metadata

Category

Text

Signature

EXACT(arg1, arg2, ... argN: Any)

This function accepts a repeating argument pattern (min args: 2).

Arity

min 2, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/text/find_search_exact.rs

DOLLAR

DOLLAR: Formats a number as currency text.

FIND

FIND: Returns the 1-based position of one text string inside another.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes EXACT perform case-sensitive comparison?Runtime metadata