ChristineJ
Wellknown Member
 Joined
 May 18, 2009
 Messages
 683
 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: