1. Open the excel document and add test data to the table; 2. Enter function =exact in cell g6 to view the usage rules of the function; 3. Complete the calculation formula =exact (e6,f6) in cell g6; 4.. The exact function in Excel can be used to compare whether the text content in two cells is consistent. If they are consistent, it returns true, otherwise it returns false. Syntax: exact (text1, text2) where text1 and text2 represent the two to be compared. Exact: Compares two strings to see if they are exactly the same, case-sensitive. Usage: Enter the function in cell c2: =exact (a2,b2) If a2=b2, it will return true; if it is not equal, it will return false. Note here that you can see the most.
How tall is Drake? Rapper gets clowned for allegedly lying about his