One sheet is older than the other, and the newer sheet is doing something wrong that the older sheet is not doing.

It's expected to return the current time to it's cell if several conditions are matched, but it returns nothing, and it's the same in all the similar cells, so the error seems to have been replicated through the sheet. Finding the error(s) in the non-functioning sheet is like looking for a needle in a haystack of about 2,000 cells!

So, what I am looking for a way to compare a FORMULA'S SYNTAX in two different cells that should be exactly the same. The inspected cells could have the same result even if there was an error in one cell's formula. What I've found only compares the cell's results.

Example 1:

Sheet1 cells A1, A2 and A3 all contain the value of 10. The formula

**=if(A1=A2),"T","F")**would return a

**"T"**since the results match.

Example 2:

Sheet 2 cell A1, A2 and A3 all contain the value of 10. The formula

**=if(A1=A3),"T","F"**) would return a

**"T"**since their results match

even though their formulas are using different cell references .

Using 'plain' English... If the syntax, not the results, in Sheet 1 cell A1, and Sheet 2 cell A1 are a match, let me know, If and ignore the cell's values.

If I find a workable formula, I can put Sheet1 on TAB1, Sheet 2 on TAB 2 , and the compare the two sheet's cells on TAB 3.....maybe!