mod吧 关注:14,879贴子:23,550
  • 0回复贴,共1

求解:EXCELL问题!!!!!!!!!!!

收藏回复

  • 61.140.128.*
IF($B5="","",IF(OR(MOD(LEFT($B5,1)+0,5)=D$4+0,MOD(MID($B5,2,1)+0,5)=D$4+0,MOD(MID($B5,3,1)+0,5)=D$4+0),"05",SUM(D4,1)))
谢帮忙分析下?谢谢


1楼2007-05-11 11:54回复