=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("","
問題已解決
溫馨提示:如果以上題目與您遇到的情況不符,可直接提問,隨時問隨時答
速問速答請清晰描述問題(財會類)發(fā)起提問,老師看到問題后覺得擅長解答才會接手解答,謝謝合作!
2021 03/31 16:05
84785038
2021 03/31 16:08
=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")麻煩老師解釋哈公式的意思
3號直播
2021 03/31 16:33
請清晰完整描述問題重新發(fā)起提問(不是追問),首問提問不規(guī)范引導正確提問!
閱讀 22
描述你的問題,直接向老師提問
相關(guān)問答
查看更多- =acct("","1122.01|00001|","JY",0,0,0,0,"BB01")+acct("","1122.02","Y",0,0,0,0,"BB01")-acct("","1231.01","Y",0,0,0,0,"BB01") 老師, 這個bb01是什么意思啊 1327
- =acct("","2211.01|0013|01","DL",0,0,0,0,"GLC")老師,金蝶報表里的取數(shù)公式,這個是啥意思呢?|0013|01"這里不懂,前面知道是應付職工薪酬工資 1604
- =IF(B4="","",IF(COUNTIFS(B:B,B4)=1,"無重復","重復報銷")) 老師,這個函數(shù)公式是什么意思? 1071
- IF($A8="華美達","月結(jié)","現(xiàn)結(jié)",IF($A8="皇尊酒店","月結(jié)","現(xiàn)結(jié)",IF($A8="星湖KTV","月結(jié)","現(xiàn)結(jié)",IF($A8="維也納音樂會所","月結(jié)","現(xiàn)結(jié)",IF($A8="金色港灣音樂會所","月結(jié)","現(xiàn)結(jié)",IF($A8="凱都會大酒店","月結(jié)","現(xiàn)結(jié)",IF($A8="新星湖KTV(金星湖)","月結(jié)","現(xiàn)結(jié)",IF($A8="*"&恒晟超市&"*","月結(jié)","現(xiàn)結(jié)")))))))) 顯示公式錯誤,是錯哪呢 866
- 角和分不能自動識別正確,幫我看下這個公式哪有問題?=IF(F27=0,\"\",IF(INT(F27),TEXT(TRUNC(F27),\"[dbnum2]\")&\"元\",\"\")&IF(MOD(F27,1)=0,\"整\",IF(TRUNC(F27,1),IF(F27=TRUNC(F27,1),TEXT(LEFT(RIGHT(F27*100,2)),\"[dbnum2]0角整\"),TEXT(RIGHT(H34*100,2),\"[dbnum2]0\"&IF(LEFT(RIGHT(H34*100,2))=\"0\",\"\",\"角\")&\"0分\")),TEXT(H34*100,\"[dbnum2]0分\")))) 630
趕快點擊登錄
獲取專屬推薦內(nèi)容