15,030
edits
Excel replace na and 0 with empty: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
No edit summary |
||
| Line 14: | Line 14: | ||
</pre> | </pre> | ||
參考資料 | |||
* [https://support.microsoft.com/zh-tw/kb/181213/zh-tw 如何使用 VLOOKUP 或 HLOOKUP 尋找完全相同的值] | |||
* [https://support.office.com/zh-tw/article/IF-%e5%87%bd%e6%95%b8-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2?ui=zh-TW&rs=zh-TW&ad=TW IF 函數] | |||
* [https://support.office.com/zh-tw/article/ISERROR-%e5%87%bd%e6%95%b8-6a5f3e99-40bc-43ce-a7c8-e79b7b6af5d5?ui=zh-TW&rs=zh-TW&ad=TW ISERROR 函數] | |||
[[Category:Spreadsheet]] [[Category:Excel]] | [[Category:Spreadsheet]] [[Category:Excel]] | ||
[[Category:Data_hygiene]] | [[Category:Data_hygiene]] | ||
[[Category:Data Science]] | [[Category:Data Science]] | ||