=MOD($J3+AG3,10)=MOD($J3-$AC3,10)=MOD($J4-5,10)=IF(COUNTIF($AJ5:$BC5,1)>=1,1,"")=IF($C3="","",SMALL($BD4:$BM4,1))

Question

=MOD($J3+AG3,10)
=MOD($J3-$AC3,10)
=MOD($J4-5,10)
=IF(COUNTIF($AJ5:$BC5,1)>=1,1,"")
=IF($C3="","",SMALL($BD4:$BM4,1))

Answer 1

MOD函数：返回两数相除的余数.结果的正负号与除数相同.
如=MOD(55,10)=5
55除以10余数是5
=IF(COUNTIF($AJ5:$BC5,1)>=1,1,"")
如果$AJ5:$BC5中,有出现1,就显示为1,否则显示空.
=IF($C3="","",SMALL($BD4:$BM4,1))
如果$C3为空,则取$BD4:$BM4区域中的第1小值.