| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
| Is it possible to get formulas to equal certain object values in E | Excel Worksheet Functions | |||
| Why do all my calculations/formulas equal zero? | Excel Discussion (Misc queries) | |||
| Macro to copy range of formulas to equal data lines | Excel Worksheet Functions | |||
| Getting 0 to equal 1 | Excel Worksheet Functions | |||
Threaded Mode
