EXACT

Returns true if both the values entered are exactly the same.

Syntax

= EXACT(value1, value2)

Parameters

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).

Return Type

Boolean.

In the case of an error, the function displays an error message: “EXACT(value1, value2): Error message”

Examples

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