<p class=lexical__paragraph dir=ltr><span style=white-space: pre-wrap;>偶爾會有遇到以下這種情況,輸入資料後需要紀錄,輸入資料當下的日期與時間。</span></p><div class=lexical__image center><div class=lexical__imageWrapper><img src=https://images.vocus.cc/47117d20-379b-4d72-9ac6-1b9d0d7a04aa.gif data-src=https://images.vocus.cc/47117d20-379b-4d72-9ac6-1b9d0d7a04aa.gif class=lazy data-original-src=https://images.vocus.cc/47117d20-379b-4d72-9ac6-1b9d0d7a04aa.gif data-lowquality=true data-width=828 data-height=683 alt=raw-image></div><div></div></div><p class=lexical__paragraph dir=ltr><span style=white-space: pre-wrap;>這個功能到底怎麼做出來的呢?來看看影片教學把她學起來吧,觀看前可以先下載練習檔案,一邊看教學一邊跟著做效果會更好唷。</span></p><p class=lexical__paragraph dir=ltr><a href=https://1drv.ms/x/s!Aj_oP6e_YHdpu0j1WS0ovsvQ2bD3?e=UZeX5e rel=noopener><span style=white-space: pre-wrap;>檔案下載</span></a></p><div class=lexical__youtube><iframe data-lexical-youtube=K3mrTHzzyHo width=600 height=340 src=https://www.youtube-nocookie.com/embed/K3mrTHzzyHo frameborder=0 allow=accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture allowfullscreen=true title=YouTube video></iframe></div><p class=lexical__paragraph dir=ltr><b><strong class=lexical__textBold style=white-space: pre-wrap;>函數翻譯:</strong></b></p><ol class=lexical__ol><li value=1 class=lexical__listItem><span style=white-space: pre-wrap;> 當C4儲存格為空白時就會顯示空白 </span></li><li value=2 class=lexical__listItem><span style=white-space: pre-wrap;>當C4儲存格不是空白時會判斷B4儲存格是否空白 </span></li><li value=3 class=lexical__listItem><span style=white-space: pre-wrap;>當B4儲存格為空白時,顯示NOW函數(函數在B4,又參照到B4陷入循環參照) </span></li><li value=4 class=lexical__listItem><span style=white-space: pre-wrap;>當B4儲存格不是空格時(B4空格所以NOW函數顯示時間),就會顯示B4自己(也就是NOW的結果)</span></li></ol><blockquote class=lexical__quote dir=ltr><span style=white-space: pre-wrap;>覺得分享有幫助到你在工作上提升效率</span><br><span style=white-space: pre-wrap;>可以追蹤</span><a href=https://vocus.cc/user/@efficiencyperson target=_blank><span style=white-space: pre-wrap;>我的方格子</span></a><span style=white-space: pre-wrap;>或請我喝杯咖啡</span><br><span style=white-space: pre-wrap;>也可以訂閱</span><a href=https://vocus.cc/newmind/home target=_blank>設計新思維</span></a><br><span style=white-space: pre-wrap;>可以看到更多增加效率的好方法唷~</span></blockquote><div class=lexical__image center><div class=lexical__imageWrapper><img src=https://images.vocus.cc/7500ec59-dede-40e3-87ab-e17f6e1fac04.gif data-src=https://images.vocus.cc/7500ec59-dede-40e3-87ab-e17f6e1fac04.gif class=lazy data-original-src=https://images.vocus.cc/7500ec59-dede-40e3-87ab-e17f6e1fac04.gif data-lowquality=true data-width=1124 data-height=773 alt=raw-image></div><div></div></div><blockquote class=lexical__quote dir=ltr><span style=white-space: pre-wrap;>職場上有相關問題,加入我的</span><a href=https://bit.ly/efficiencypersonline target=_blank>社群討論唷~</span></a></blockquote><blockquote class=lexical__quote dir=ltr><a href=https://www.instagram.com/efficiency_person/ target=_blank><span style=white-space: pre-wrap;>追蹤我的IG</span></a></blockquote><blockquote class=lexical__quote dir=ltr><a href=https://www.facebook.com/profile.php?id=100087433032294 target=_blank><span style=white-space: pre-wrap;>追蹤我的粉絲團</span></a></blockquote><blockquote class=lexical__quote dir=ltr><a href=https://dcard.me/@gary79205 target=_blank><span style=white-space: pre-wrap;>追蹤我的Dcard</span></a></blockquote>