00:10:00
問題已解決
IF($A8="華美達(dá)","月結(jié)","現(xiàn)結(jié)",IF($A8="皇尊酒店","月結(jié)","現(xiàn)結(jié)",IF($A8="星湖KTV","月結(jié)","現(xiàn)結(jié)",IF($A8="維也納音樂會(huì)所","月結(jié)","現(xiàn)結(jié)",IF($A8="金色港灣音樂會(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ò)哪呢
溫馨提示：如果以上題目與您遇到的情況不符，可直接提問，隨時(shí)問隨時(shí)答
冉老師
金牌答疑老師
職稱：注冊會(huì)計(jì)師,稅務(wù)師,中級(jí)會(huì)計(jì)師,初級(jí)會(huì)計(jì)師,上市公司全盤賬務(wù)核算及分析
你好，學(xué)員，這個(gè)是亂碼的
2022 09/29 12:49
84784960 
2022 09/29 12:54
可能是發(fā)過去變這樣了
冉老師 
2022 09/29 12:55
全是亂碼的，學(xué)員，這個(gè)
84784960
2022 09/29 12:55
IF($A8="華美達(dá)","月結(jié)","現(xiàn)結(jié)",IF($A8="皇尊酒店","月結(jié)","現(xiàn)結(jié)",IF($A8="星湖KTV","月結(jié)","現(xiàn)結(jié)",IF($A8="維也納音樂會(huì)所","月結(jié)","現(xiàn)結(jié)",IF($A8="金色港灣音樂會(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é)"))))))))
冉老師
2022 09/29 13:22
不行，顯示的還是亂碼
84784960
2022 09/29 18:58
不會(huì)啊，重發(fā)的不是亂碼啊
冉老師
2022 09/29 19:26
是的，老師刷新了一下是亂碼的
閱讀 934
描述你的問題，直接向老師提問
60
意見反饋
