How To Reduce This Function In MS Excel 2013

Question

I'm looking to reduce this function In MS Excel 2013 ! my function is :

=IF(OR(AND(B5>E3;F3=0);AND(B5>E4;F4=0);AND(B5>E5;F5=0);AND(B5>E6;F6=0);AND(B5>E7;F7=0);AND(B5>E8;F8=0);AND(B5>E9;F9=0);AND(B5>E10;F10=0));"true";"false")

My function is currently working with success :D!

But, I hope to reduce (shorten) it because I want to repeat this format in many other places in the same Excel File.

Answer 1

You can use this:

=IF(COUNTIFS(E:E,"<"&B5,F:F,0)>0,"TRUE","FALSE")

In your format:

=IF(COUNTIFS(E:E;"<"&B5;F:F;0)>0;"TRUE";"FALSE")