1 line
121 KiB
Plaintext
1 line
121 KiB
Plaintext
|
{"ID":"20250915093450-bwdthap","Spec":"2","Type":"NodeDocument","Properties":{"id":"20250915093450-bwdthap","title":"数据库EXCEL尝试","type":"doc","updated":"20250916154053"},"Children":[{"ID":"20250915112645-0rzeinu","Type":"NodeParagraph","Properties":{"id":"20250915112645-0rzeinu","updated":"20250915112717"},"Children":[{"Type":"NodeText","Data":"与2025_09_15_11:25完成"}]},{"ID":"20250915112718-ihvhcuh","Type":"NodeParagraph","Properties":{"id":"20250915112718-ihvhcuh","updated":"20250915113859"},"Children":[{"Type":"NodeText","Data":"新问题，如何去除掉0，和#\tN/A"}]},{"ID":"20250915113813-d6g65nz","Type":"NodeParagraph","Properties":{"id":"20250915113813-d6g65nz","updated":"20250915113813"}},{"ID":"20250915114117-obr8ae7","Type":"NodeParagraph","Properties":{"id":"20250915114117-obr8ae7","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"好的，在 Excel 中去除 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"0"},{"Type":"NodeText","Data":" 和 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"#N/A"},{"Type":"NodeText","Data":" 错误值是常见的数据清理需求。根据你的最终目的（是单纯为了“看起来干净”还是为了“后续计算”），有以下几种方法。"}]},{"ID":"20250915114117-yfdrzvf","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20250915114117-yfdrzvf","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"方法一：使用 IF 和 IFERROR 函数组合（推荐用于后续计算）"}]},{"ID":"20250915114117-ubis0df","Type":"NodeParagraph","Properties":{"id":"20250915114117-ubis0df","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"这是最灵活、最常用的方法，它会在源数据基础上创建一个新的、干净的数据列，不影响原始数据，便于后续的统计、计算或制作图表。"}]},{"ID":"20250915114117-ad529ya","Type":"NodeParagraph","Properties":{"id":"20250915114117-ad529ya","updated":"20250915114117"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"公式原理："}]},{"ID":"20250915114117-syjpkix","Type":"NodeList","ListData":{"Typ":1},"Properties":{"id":"20250915114117-syjpkix","updated":"20250915114117"},"Children":[{"ID":"20250915114117-fvl5ugj","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"MS4=","Num":1},"Properties":{"id":"20250915114117-fvl5ugj","updated":"20250915114117"},"Children":[{"ID":"20250915114117-xf0uuil","Type":"NodeParagraph","Properties":{"id":"20250915114117-xf0uuil","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"先用 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"IFERROR"},{"Type":"NodeText","Data":" 函数将 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"#N/A"},{"Type":"NodeText","Data":" 等错误值转换为空单元格 ("},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"\"\""},{"Type":"NodeText","Data":") 或其他值（如 0）。"}]}]},{"ID":"20250915114117-7px9akz","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Mi4=","Num":2},"Properties":{"id":"20250915114117-7px9akz","updated":"20250915114117"},"Children":[{"ID":"20250915114117-9l1x0yk","Type":"NodeParagraph","Properties":{"id":"20250915114117-9l1x0yk","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"再在外层套一个 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"IF"},{"Type":"NodeText","Data":" 函数，判断上一步的结果是否为 0，如果是则也转换为空单元格。"}]}]}]},{"ID":"20250915114117-3kvs2cp","Type":"NodeParagraph","Properties":{"id":"20250915114117-3kvs2cp","updated":"20250915114117"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"假设原始数据在 A 列，从 A2 开始。"}]},{"ID":"20250915114117-sze9c4t","Type":"NodeParagraph","Properties":{"id":"20250915114117-sze9c4t","updated":"20250915114117"},"Children":[{"Type":"NodeText","Data":"在 B2
|