作者查詢 / toroma
作者 toroma 在 PTT [ Office ] 看板的留言(推文), 共108則
限定看板:Office
看板排序:
全部Office108intltrade101BabyMother35Liu22GVO21dictionary16rabbit14License13PingTung10StupidClown10KUAS9study8CareerLady7learnyf6first-wife5iOS5BabyProducts4BuyTogether4Bank_Service3BBSmovie3DailyArticle3Kaohsiung3Lifeismoney3piano3Polytechnic3tax3WomenTalk3Anti-ramp2Boy-Girl2Emergency2FJU-LS94b2Patty_Hou2share2t-management2Wallpaper2WebRadio2WorkanTravel2ainori1allergy1Bowling1BuRuRadio1CareerPlan1creditcard1CS91Peace1CSMU-CH1CSMU-LS891CSMU-MED961CSMU-PT901CTSH923011CTSH953031DSLR1einvoice1Examination1fastfood1FJU-ACC94b1FJU-ACCR941FJU_AD-041FJU_CA_981Fsm90-3171give1Golden-Award1handsomechef1HelpBuy1humanity1hypermall1Instant_Mess1Insurance1ISU1JH30th3061kawaii1KS91-3061KS92-3121KUAS_IB1Kusan_89-3121LineageII1Little-Games1marriage1maruko1MayDay1model1Nanofan1NCCU04_LANDG1NCCU08_Math1NCCU08_MJOUR1NCHU-AGR021NCHU-AGR981NCHU-PP871NDHU-phy971NDMC-PH241NetRumor1Nintendo1NIUEE93a1NKNU1NSYSU1NTPU-ECONM941NTPU-STAT931NTUBA98study1NTUE-ME971NTUST-DT92-11NTUT_EE490A1onlychild1PCCU-AT-91C1Pisces1Preschooler1regimen1Salary1SCU_CIS-90B1SCU_CIS-92A1Stock1TA_AN1TaiwanDrama1teeth_salon1Transport971TS_32th_3011USC1WinNT1Yanzi1YMU_bioMed961YZU_MBA941<< 收起看板(119)
33F推: 謝謝S大04/24 10:41
4F→: 謝謝S大,很受用^_^10/05 23:21
1F→:自訂動畫>進入>色彩打字機 ? 是這個嗎04/28 11:14
1F推:資料剖析07/16 20:52
1F推:=countif(a1:g20,">100")06/18 10:28
2F→:他沒有做群組,就只有寫月份,所以我看了很久,還是不懂06/13 14:29
4F→:原來是在群組欄位,謝謝你~~~~06/13 17:39
1F推:什麼是"4/16 a欄為4/20"?04/21 23:44
1F推:工具列按右鍵,取消最小化功能區即可11/09 21:48
2F→:謝謝,應該是ok了08/18 21:27
3F→:請問如果要讓其中一個儲存格"自動",另一格"手動",這樣該08/19 20:48
4F→:怎麼設定比較好?08/19 20:48
4F→:謝謝1樓的教導,我用上面的範例試了之後是ok的,不過,不知08/07 22:16
5F→:道是不是因為我的日期欄和金額欄是有用公式的關係,試了之08/07 22:17
6F→:後,還是失敗>"<, 我的金額欄,是由c1*c2組成,日期欄是用08/07 22:18
7F→:if(g1="OK",f1,g1)會因為這個原因,使得公式呈現#value嗎?08/07 22:19
8F→:抱歉,我找到問題了,因為我的金額欄,有一欄有"文字",所08/07 22:42
9F→:以把"文字"去除,公式就正常了,謝謝G大的幫忙!!08/07 22:43
10F→:請問如果還要再加個條件, ex.某欄的資料=YES,才要加總的話08/07 23:03
11F→:是否可以用上面的公式再加上*(欄1:欄100)="YES") ?08/07 23:04