★Word/Excel (MS-OFFICE) 初心者スレッド Part39★

★Word/Excel (MS-OFFICE) 初心者スレッド Part39★at PCQA

★Word/Excel (MS-OFFICE) 初心者スレッド Part39★ - 暇つぶし2ch595:ひよこ名無しさん
11/09/17 10:35:37.49
>>594
=IF(LEFT(A1,1)="D","佐藤",
IF(ISERROR(MID(A1,2,2)*1),"田中",
IF(OR(MID(A1,2,2)*1=45,MID(A1,2,2)*1=13,AND(MID(A1,2,2)*1>65,MID(A1,2,2)*1<70)),"鈴木",
"田中")))

次ページ