#### ChristineJ

##### Well-known Member

- Joined
- May 18, 2009

- Messages
- 746

- Office Version
- 365

- Platform
- Windows

I'd like help with a formula that would return "Correct" if true and "" (blank) if false. All of the cells in the ranges have numerical entries or are blank.

IF the values in BN846:BN865 equal those in the corresponding row in CW846:CW865

and the values in BP846:BP865 equal those in the corresponding row in CY846:CY865

and the values in BR846:BR865 equal those in the corresponding row in DA846:DA865

and the values in BY846:BY865 equal those in the corresponding row in DC846:DC865

BUT it should only check for equality in those rows in which the value in column DF in the same row is >440 and <461

If the value in a row in column DF is <441 or >460, it does not matter if the values above in the same row match or not.

IF the values in BN846:BN865 equal those in the corresponding row in CW846:CW865

and the values in BP846:BP865 equal those in the corresponding row in CY846:CY865

and the values in BR846:BR865 equal those in the corresponding row in DA846:DA865

and the values in BY846:BY865 equal those in the corresponding row in DC846:DC865

BUT it should only check for equality in those rows in which the value in column DF in the same row is >440 and <461

If the value in a row in column DF is <441 or >460, it does not matter if the values above in the same row match or not.

Last edited: