Thread: Formulas Equal?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Formulas Equal?

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.

Im 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