00:10:00
問(wèn)題已解決
老師，我想問(wèn)下這一個(gè)單元格如何能把里面的"工程地點(diǎn)"和"姓名"分開呢？
溫馨提示：如果以上題目與您遇到的情況不符，可直接提問(wèn)，隨時(shí)問(wèn)隨時(shí)答
光標(biāo)定位到 地點(diǎn)的點(diǎn)字后面，按 alt + enter強(qiáng)制換行即可
2019 08/10 15:53
閱讀 594 溫馨提示：如果以上題目與您遇到的情況不符，可直接提問(wèn)，隨時(shí)問(wèn)隨時(shí)答 閱讀 594
描述你的問(wèn)題，直接向老師提問(wèn)相關(guān)問(wèn)答
查看更多-
=acct("","1401:1411","Y",0,0,0,0,"GLC","Company")+acct("","1421","Y",0,0,0,0,"GLC","Company")+acct("","1431","Y",0,0,0,0,"GLC","Company")-acct("","1471","Y",0,0,0,0,"GLC","Company")+acct("","5401","Y",0,0,0,0,"GLC","Company")+acct("","
22 -
如圖，已知姓名對(duì)應(yīng)的性別，當(dāng)想節(jié)省時(shí)間，每次錄入姓名，如何讓性別列自動(dòng)跳出是"男"還是"女"？
1561
-
老師好，有一個(gè)表格
"張三 虹口區(qū)" "張三”
"李四 黃浦區(qū)" "李四”
"王五 長(zhǎng)寧區(qū)" "王五”
……
老師好，怎么用Excel函數(shù)獲得虹口區(qū)
黃浦區(qū)
長(zhǎng)寧區(qū)
非常感謝，
1164
-
IF($A8="華美達(dá)","月結(jié)","現(xiàn)結(jié)",IF($A8="皇尊酒店","月結(jié)","現(xiàn)結(jié)",IF($A8="星湖KTV","月結(jié)","現(xiàn)結(jié)",IF($A8="維也納音樂(lè)會(huì)所","月結(jié)","現(xiàn)結(jié)",IF($A8="金色港灣音樂(lè)會(huì)所","月結(jié)","現(xiàn)結(jié)",IF($A8="凱都會(huì)大酒店","月結(jié)","現(xiàn)結(jié)",IF($A8="新星湖KTV(金星湖）","月結(jié)","現(xiàn)結(jié)",IF($A8="*"&恒晟超市&"*","月結(jié)","現(xiàn)結(jié)"))))))))
顯示公式錯(cuò)誤，是錯(cuò)哪呢
969
-
=IF(B4="","",IF(COUNTIFS(B:B,B4)=1,"無(wú)重復(fù)","重復(fù)報(bào)銷"))
老師，這個(gè)函數(shù)公式是什么意思？
2130
趕快點(diǎn)擊登錄
獲取專屬推薦內(nèi)容
意見反饋
