Hi Richard,

Your formula will check if the results of the formulas in A1 on both sheets are equal.
It will not check the whole range and it will not check the formulas. You need VBA for that.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Richard" wrote in message ...
| OS: XP
| Excel 2000
|
| I need to check (2) two different spreadsheets in (2) two different
| workbooks to see if all the formulas are equal.
|
| I'm using an IF statement.
|
| =IF('[Dashboard Kent County.xls]Capacity Violations'!$A$1:$H$31='Capacity
| Violations'!$A$1:$H$31,"Yes","No")
|
| Even if I change the formulas the statement still returns Yes.
|
| Please Help.
|
| Thanks in Advance
|
| --
| Richard