[已解决][求助]数字的提取

风随心动

19223805	Y
19220419	","K"),"Y")" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">K	第5位为0,用K表示
49213224	","K"),"Y")" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">Y
37229410	","K"),"Y")" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">Y	第5位为9,用P表示
		第5位为其余的时用Y表示

我用的这公式，用出来没对。=IF(MID(A2,5,1)="0",IF(MID(A2,5,1)="9","P","K"),"Y")

请帮我看看塞，谢谢！

最佳答案

月排行榜 / 总排行榜

xiaopei050

2009-9-10 17:06

=IF(MID(A2,5,1)="0","K",IF(MID(A2,5,1)="9","","Y"))

跳转到最佳答案楼层

xiaopei050

=IF(MID(A2,5,1)="0","K",IF(MID(A2,5,1)="9","","Y"))

风随心动

谢谢