id: 574afacc49dd4d9d9dded0d45666f66a
parent_id: 
item_type: 1
item_id: abf8474850754860b29235cac72aa001
item_updated_time: 1764345610548
title_diff: "[{\"diffs\":[[1,\"免费好用的Excel公式生成工具（免登录）\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":21}]"
body_diff: "[{\"diffs\":[[1,\"<html>\\\r\\\n<head>\\\r\\\n  <title>免费好用的Excel公式生成工具（免登录）</title>\\\r\\\n  <basefont face=\\\"微软雅黑\\\" size=\\\"2\\\" />\\\r\\\n  <meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html;charset=utf-8\\\" />\\\r\\\n  <meta name=\\\"exporter-version\\\" content=\\\"YXBJ Windows/608924 (zh-CN, DDL); Windows/10.0.0 (Win64); EDAMVersion=V2;\\\"/>\\\r\\\n  <meta name=\\\"content-class\\\" content=\\\"yinxiang.peso.superNote\\\"/>\\\r\\\n  <meta name=\\\"application-data:yinxiang.noteLayout\\\" content=\\\"{\\\"lineSpace\\\":\\\"recommend\\\",\\\"paragraphSpace\\\":\\\"recommend\\\"}\\\"/>\\\r\\\n  <style>\\\r\\\n\\tbody, td {\\\r\\\n\\t  font-family: 微软雅黑;\\\r\\\n\\t  font-size: 12pt;\\\r\\\n\\t}\\\r\\\n  </style>\\\r\\\n</head>\\\r\\\n<body>\\\r\\\n<a name=\\\"33402\\\"></a>\\\r\\\n<h1>免费好用的Excel公式生成工具（免登录）</h1>\\\r\\\n\\\r\\\n<div><span style=\\\"\\\"><div style=\\\"max-width: 700px;\\\"><p></p><div style=\\\"--en-blockquote: true; box-sizing: border-box; border-left: 3px solid #b4c0cc; background-position: initial initial; background-repeat: initial initial;\\\"><div>原文链接: <a href=\\\"http://mp.weixin.qq.com/s?__biz=Mzg4NDk0Nzk4Mw==&amp;mid=2247484753&amp;idx=1&amp;sn=4676745a87900f1d49b4258be131c728&amp;chksm=ce78cbf7fe65a1b82ec95a5bc7d4a47a4bf6bdad7f6d838ce776191fad7e3e48cfb594d131ed&amp;mpshare=1&amp;scene=1&amp;srcid=1123H4IK5l8ZwRsjRWxtpklC&amp;sharer_shareinfo=8c9c414358119423f42c6edbc5be38e2&amp;sharer_shareinfo_first=8c9c414358119423f42c6edbc5be38e2#rd\\\"><span>http://mp.weixin.qq.com/s?__biz=Mzg4NDk0Nzk4Mw==&amp;mid=2247484...</span></a></div></div><p></p><div style=\\\"-webkit-tap-highlight-color: transparent;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent;\\\">原创</span><span style=\\\"-webkit-tap-highlight-color: transparent;\\\"> AI技术迷 </span><span style=\\\"-webkit-tap-highlight-color: transparent;\\\"><a style=\\\"-webkit-tap-highlight-color: transparent;\\\"> AI技术迷 </a></span><span style=\\\"-webkit-tap-highlight-color: transparent;\\\"><em style=\\\"-webkit-tap-highlight-color: transparent;\\\"></em></span></div><div style=\\\"-webkit-tap-highlight-color: transparent;\\\"><div style=\\\"-webkit-tap-highlight-color: transparent; color: black; word-break: break-word; text-align: left; letter-spacing: 2px; background-image: linear-gradient(90deg,rgba(50,0,0,0.05) 3%,rgba(0,0,0,0) 3%),linear-gradient(360deg,rgba(50,0,0,0.05) 3%,rgba(0,0,0,0) 3%); background-size: 20px 20px; background-position: center center;\\\"><p style=\\\"-webkit-tap-highlight-color: transparent; word-spacing: 2px;\\\"><strong style=\\\"-webkit-tap-highlight-color: transparent; color: rgb(145,109,213);\\\">「公式生成器」</strong>是使用人工智能根据用户提供的数据输入和要求自动生成 Excel 公式的工具，可以自动处理几乎所有 Excel 中的计算，支持各种应用场景。</p><h2 style=\\\"-webkit-tap-highlight-color: transparent; font-weight: bold; font-size: 22px;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; border-left: 5px solid rgb(145,109,213);\\\">快速使用</span></h2><p style=\\\"-webkit-tap-highlight-color: transparent; word-spacing: 2px;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; color: rgb(145,109,213);\\\">例1：A列为数量，B列为价格，计算C列总金额</span></p><p style=\\\"-webkit-tap-highlight-color: transparent; text-align: center;\\\"><img src=\\\":/90202bc12283407cb55af01a911d5f88\\\" type=\\\"image/png\\\" data-filename=\\\"640.png\\\" style=\\\"--en-marks: %7B%22align%22%3A%22center%22%7D; -webkit-tap-highlight-color: transparent; width: auto; height: auto;\\\" width=\\\"auto\\\"/></p><p style=\\\"-webkit-tap-highlight-color: transparent; word-spacing: 2px;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; color: rgb(145,109,213);\\\">例2：计算B列中销售超过50个单位的商品在C列中的平均销售额</span></p><p style=\\\"-webkit-tap-highlight-color: transparent; text-align: center;\\\"><img src=\\\":/8e055f38b60340aebabd16732bda4a32\\\" type=\\\"image/png\\\" data-filename=\\\"640.png\\\" style=\\\"--en-marks: %7B%22align%22%3A%22center%22%7D; -webkit-tap-highlight-color: transparent; width: auto; height: auto;\\\" width=\\\"auto\\\"/></p><h2 style=\\\"-webkit-tap-highlight-color: transparent; font-weight: bold; font-size: 22px;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; border-left: 5px solid rgb(145,109,213);\\\">主要功能</span></h2><p style=\\\"-webkit-tap-highlight-color: transparent; word-spacing: 2px;\\\"><strong style=\\\"-webkit-tap-highlight-color: transparent; color: rgb(145,109,213);\\\">「数学计算」</strong>：公式生成器能够轻松执行基本的算术运算和统计计算，例如 AVERAGE、MAX、MIN、RANK 和 STDEV，甚至复杂的三角函数、对数计算和工程方程式，仅需少量描述即可生成。</p><p style=\\\"-webkit-tap-highlight-color: transparent; word-spacing: 2px;\\\"><strong style=\\\"-webkit-tap-highlight-color: transparent; color: rgb(145,109,213);\\\">「数据处理」</strong>：对于财务、销售和营销等数据密集的部门，公式生成器可自动化繁琐的任务，包括筛选、排序、去重和条件填充。无需编写代码即可实现 AI 驱动的动态数据过滤、文本列连接、以及随机分组功能。</p><p style=\\\"-webkit-tap-highlight-color: transparent; word-spacing: 2px;\\\"><strong style=\\\"-webkit-tap-highlight-color: transparent; color: rgb(145,109,213);\\\">「文本处理」</strong>：在 Excel 中常见的文本整理任务，如连接、提取子字符串和大小写转换等，使用公式生成器后可以轻松完成，助您专业管理数据库中的文本内容。</p><p style=\\\"-webkit-tap-highlight-color: transparent; word-spacing: 2px;\\\"><strong style=\\\"-webkit-tap-highlight-color: transparent; color: rgb(145,109,213);\\\">「逻辑运算」</strong>：无需编写脚本，即可轻松实现基于 IF 语句的条件逻辑。多层次的 IF、IFS 和 SWITCH 公式，便于创建带交互控件的动态报告和仪表板，显著提升工作效率。</p><p style=\\\"-webkit-tap-highlight-color: transparent; word-spacing: 2px;\\\">借助 Excel 公式生成器，无论是简单的运算还是复杂的数据处理，都能轻松实现，极大降低了上手难度，适用于各类用户。</p><p style=\\\"-webkit-tap-highlight-color: transparent; word-spacing: 2px;\\\"><strong style=\\\"-webkit-tap-highlight-color: transparent;\\\">免费体验地址：https://www.akkio.com/tool/ai-excel-formula-generator</strong></p></div><p style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; letter-spacing: normal; text-align: left; background-color: rgb(255,255,255); color: black;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: rgb(255,0,0);\\\"><strong style=\\\"-webkit-tap-highlight-color: transparent; outline: 0;\\\"><strong style=\\\"-webkit-tap-highlight-color: transparent; outline: 0;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; text-decoration-style: solid; text-decoration-color: rgb(0,0,0);\\\">往期回顾：</span></strong></strong></span></p><p style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; letter-spacing: normal; text-align: left; background-color: rgb(255,255,255); color: black;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; text-decoration-style: solid; text-decoration-color: rgb(0,0,0); color: rgb(255,0,0);\\\"><a href=\\\"http://mp.weixin.qq.com/s?__biz=Mzg4NDk0Nzk4Mw==&amp;mid=2247484559&amp;idx=1&amp;sn=9b2356f01d6e6bd6075ec4f93eef4645&amp;chksm=cfb129eff8c6a0f981342871b3e02bd229ba7fea000d734bcd83f48c1ed80f7057aa6128f7a8&amp;scene=21#wechat_redirect\\\" style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: var(--weui-LINK); cursor: default;\\\" target=\\\"_blank\\\">1.“黑神话：芝士饼&quot;，原生开发平台!</a></span><span style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: rgb(255,0,0);\\\"><strong style=\\\"-webkit-tap-highlight-color: transparent; outline: 0;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; text-decoration-style: solid; text-decoration-color: rgb(0,0,0);\\\"><a href=\\\"http://mp.weixin.qq.com/s?__biz=Mzg4NDk0Nzk4Mw==&amp;mid=2247484559&amp;idx=1&amp;sn=9b2356f01d6e6bd6075ec4f93eef4645&amp;chksm=cfb129eff8c6a0f981342871b3e02bd229ba7fea000d734bcd83f48c1ed80f7057aa6128f7a8&amp;scene=21#wechat_redirect\\\" style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: var(--weui-LINK); cursor: default;\\\" target=\\\"_blank\\\"></a><br style=\\\"-webkit-tap-highlight-color: transparent; outline: 0;\\\"/></span></strong></span></p><p style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; letter-spacing: normal; text-align: left; background-color: rgb(255,255,255); color: black;\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: rgb(255,0,0);\\\"><a href=\\\"http://mp.weixin.qq.com/s?__biz=Mzg4NDk0Nzk4Mw==&amp;mid=2247484545&amp;idx=1&amp;sn=0ac779d333c3df71ade61d11f6788a98&amp;chksm=cfb129e1f8c6a0f784314da7d67f22f85a3876bb7faedc38df18065b66cd7a3c4dbe14bf3ace&amp;scene=21#wechat_redirect\\\" style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: var(--weui-LINK); cursor: default;\\\" target=\\\"_blank\\\">2.“白日梦AI：文转视频神器&quot;</a></span></p><p style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; letter-spacing: normal; text-align: left; background-color: rgb(255,255,255);\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: rgb(87,107,149);\\\">3.<a href=\\\"http://mp.weixin.qq.com/s?__biz=Mzg4NDk0Nzk4Mw==&amp;mid=2247484524&amp;idx=1&amp;sn=35d25af8f3293fbb4b906d0e5021163e&amp;chksm=cfb1290cf8c6a01a716834e9f673386bde1546b4f67462c5afc21e00ec26c688d708832f70ed&amp;scene=21#wechat_redirect\\\" style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: var(--weui-LINK); cursor: default;\\\" target=\\\"_blank\\\">心流AI：让知识触手可及，让学习工作更高效</a></span></p><p style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; letter-spacing: normal; text-align: left; background-color: rgb(255,255,255);\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: rgb(87,107,149);\\\"><a href=\\\"http://mp.weixin.qq.com/s?__biz=Mzg4NDk0Nzk4Mw==&amp;mid=2247484524&amp;idx=1&amp;sn=35d25af8f3293fbb4b906d0e5021163e&amp;chksm=cfb1290cf8c6a01a716834e9f673386bde1546b4f67462c5afc21e00ec26c688d708832f70ed&amp;scene=21#wechat_redirect\\\" style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: var(--weui-LINK); cursor: default;\\\" target=\\\"_blank\\\"></a>4.<a href=\\\"http://mp.weixin.qq.com/s?__biz=Mzg4NDk0Nzk4Mw==&amp;mid=2247484505&amp;idx=1&amp;sn=fd45b61d8617951bab72f750d201c574&amp;chksm=cfb12939f8c6a02f3a77ccf41cb0354d02e0328a763b7fbed3c40ff53164bf2c59b022e9e6ec&amp;scene=21#wechat_redirect\\\" style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: var(--weui-LINK); cursor: default;\\\" target=\\\"_blank\\\">国产AI视频生成工具“清影”，30秒快速生成！</a></span></p><p style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; letter-spacing: normal; text-align: left; background-color: rgb(255,255,255);\\\"><span style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: rgb(87,107,149);\\\"><a href=\\\"http://mp.weixin.qq.com/s?__biz=Mzg4NDk0Nzk4Mw==&amp;mid=2247484505&amp;idx=1&amp;sn=fd45b61d8617951bab72f750d201c574&amp;chksm=cfb12939f8c6a02f3a77ccf41cb0354d02e0328a763b7fbed3c40ff53164bf2c59b022e9e6ec&amp;scene=21#wechat_redirect\\\" style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: var(--weui-LINK); cursor: default;\\\" target=\\\"_blank\\\"></a>5.<a href=\\\"http://mp.weixin.qq.com/s?__biz=Mzg4NDk0Nzk4Mw==&amp;mid=2247484434&amp;idx=1&amp;sn=532dcfddd9f35aaf4bb3213ea8b8de0d&amp;chksm=cfb12972f8c6a06482dca58f0701b6d2a3c969b34559b72f309c13ec4406d2bf9a68d9d7a558&amp;scene=21#wechat_redirect\\\" style=\\\"-webkit-tap-highlight-color: transparent; outline: 0; color: var(--weui-LINK); cursor: default;\\\" target=\\\"_blank\\\">对标Kimi的橙篇，能否成为你的创作利器？</a></span></p></div></div></div></div></div></span>\\\n</div></body></html>\\u0000\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":10738}]"
metadata_diff: {"new":{"id":"abf8474850754860b29235cac72aa001","parent_id":"f67288c3a0be4374b5d532b5dcc3aabc","latitude":"0.00000000","longitude":"0.00000000","altitude":"0.0000","author":"","source_url":"","is_todo":0,"todo_due":0,"todo_completed":0,"source":"joplin-desktop","source_application":"net.cozic.joplin-desktop","application_data":"","order":1764348836108,"markup_language":2,"is_shared":0,"share_id":"","conflict_original_id":"","master_key_id":"","user_data":"","deleted_time":0},"deleted":[]}
encryption_cipher_text: 
encryption_applied: 0
updated_time: 2025-11-28T21:04:08.585Z
created_time: 2025-11-28T21:04:08.585Z
type_: 13