Returns true if both the values entered are exactly the same.
= EXACT(value1, value2)
value1 |
A value which has to be compared. The value can be specified as an integer (e.g., 37), a decimal value (e.g., 37.48), as a string (“word”), or as the value of a variable (e.g, UnitPrice). |
value2 |
A value which has to be compared. The value can be specified as an integer (e.g., 37), a decimal value (e.g., 37.48), as a string (“word”), or as the value of a variable (e.g, UnitPrice). |
Boolean.
In the case of an error, the function displays an error message: “EXACT(value1, value2): Error message”
Example |
Returns |
= EXACT(37, 37) |
True |
= EXACT(“t est”, “test”) |
False |
= EXACT(37, “37”) |
True |
= EXACT(OrderID, 10248) |
True if the value of OrderID is 10248 |