正文 excel批量判断车限行 访客 V游客 /49分钟前 /2 阅读 0814 excel车辆限号公式B2输入 =if(A1="","",lookup(if(isnumber(right(A1,1)*1),right(A1,1)*1, mid(A1,6,1)*1),{0,1,2,3,4,5,6,7,8,9},{"周一","周一","周二","周三","周四","周二","周四","周三","周二","周一"})) 往下拖公式
