判斷 三種狀況 (10505)

F3=IFERROR(LOOKUP(1,0/(MOD(C3+D3*{-1,1},{5,10})=0),{"对应","补"}),"无补无对应")

另解=IF(OR(C3+D3={10,0}),"补",IF(ABS(C3-D3)=5,"对应","无补无对应"))