Explain formula

[LoganTrk]

Somebody explain me this formula please. I need your help
=IF(E3=0;"";IF(COUNTIFS(G:G;G3;AD:AD;">="&AD3;AD:AD;"<="&AE3)>1;"WRONG";"OK"))
[TABLE="width: 472"]
<tbody>[TR]
[TD]G
[/TD]
[TD]AD
[/TD]
[TD]AE
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]10000571
[/TD]
[TD]13/12/2018 15:30
[/TD]
[TD]13/12/2018 19:30
[/TD]
[TD]OK
[/TD]
[/TR]
[TR]
[TD]10000571
[/TD]
[TD]13/12/2018 15:30
[/TD]
[TD]13/12/2018 19:30
[/TD]
[TD]OK
[/TD]
[/TR]
[TR]
[TD]11500834
[/TD]
[TD]06/12/2018 15:00

[/TD]
[TD]06/12/2018 21:00

[/TD]
[TD]WRONG
[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott T]

IF(logical_test,value_if_true,value_if_false)

If E3=0 then return blank, that is what "" is. if E3 is not 0,logical text is false, then the second if statement is run the COUNTIFS will count based on the criteria of value in G = G3 AND Value in AD is greater than or equal to AD3 AND AD is less than or equal to AE3. If that count is greater then 1 the WRONG is returned if not then "OK" is returned.

 

[LoganTrk]

thnks