EXACT

Modified on Wed, 29 May at 1:17 PM

Introduction

Returns true if the given two strings are exactly the same.


FORMULAEXACT(col_1, col_2)
EXAMPLE FORMULAEXACT(Gigasheet, gigasheet)
EXAMPLE INPUTgigasheet
EXAMPLE OUTPUTFALSE


Sample Usage


Valid ExamplesInvalid Examples
EXACT(col_1, col_2)EXACT(col_1, col_2, col_3)





Notes

  • Comparing columns must be exactly the same.
  • EXACT formula is case sensitive 
  • Can used on Date and Number columns
  • No more than two columns can be compared at a time

See Also


Still having issues? Contact us at support@gigasheet.com

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article