ENDSWITH
checks if text ends with suffix · a deepcalc original · no excel equivalent · no sheets equivalent
signature
ENDSWITH(text, suffix)
returns: text
| argument | required |
|---|---|
| text | required |
| suffix | required |
examples
formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.
fx
=ENDSWITH("hello world", "world") true | A | |
|---|---|
| 1 | 10 |
fx
=ENDSWITH(A1, "test") false