質問: エクセルご指導下さい。
回答: =IF(A1="","",IF(F1="-","-",LEFT(A1,1)&"-"&F1)) ですかね? F1に直接表示なら、 =IF(A1="","",IF(COUNT(B1:E1)=0,"-",LEFT(A1,1)&"-"&IF(B1>0,"A",IF(C1>0,"B",IF(D1>0,"C","D")))))