Returning a 1 if the rules are met

[Craig123486]

Hi,

Been scanning the forum to see if there is something similar, but can't find anything that works. Hopefully someone will be able to help.

I need a formula which looks at certain columns and if the criteria match's, it returns a 1.


The first is on example 1

the formula needs to find a match in column J
in column N a SG has to be a debit value (in black) in column U and a DQ needs to be a credit value (in red) in column U
if the credit and debit match (it equals zero) it returns a 1 in column W on them entries


The second example is the same but looks at the Doc.Date in column Q also.

Again needs to find a match in column J
in column N a SL has to be a debit value in column U and a SG needs to be credit value in column U
It needs to look at the Doc Date in column R but minus 1 day of that date (so the credits on the 7th will match against the debits on the 6th)
if it match's to zero it returns a 1 in column W on them entries


Can anyone help? I can go into it more if the above doesn't make sense.

Thank you in advance!