id: 703ddaea7d024848aab7405c2151c332
parent_id: 
item_type: 1
item_id: 78fee93e7c44401992dd531c7879a32a
item_updated_time: 1764345500111
title_diff: "[{\"diffs\":[[1,\"EXCEL工作表中如何将含税金额换算为不含税金额_360新知\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":30}]"
body_diff: "[{\"diffs\":[[1,\"<html>\\\r\\\n<head>\\\r\\\n  <title>EXCEL工作表中如何将含税金额换算为不含税金额_360新知</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  <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=\\\"29090\\\"></a>\\\r\\\n<h1>EXCEL工作表中如何将含税金额换算为不含税金额_360新知</h1>\\\r\\\n\\\r\\\n<div><span>\\\n  <div style=\\\"--en-clipped-content:article; --en-clipped-source-url:https://xinzhi.wenda.so.com/m/a/1630026482206613; --en-clipped-source-title:EXCEL工作表中如何将含税金额换算为不含税金额_360新知;\\\">\\\n<div><br/></div><div style=\\\"min-height: 3460px; font-size: 16px; display: block; min-width: 100%; position: relative;\\\"> <div style=\\\"font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;\\\"><div style=\\\"background:rgb(240, 240, 240);font-family:arial;-webkit-font-smoothing:antialiased;overflow-x:hidden;font-size:18px;color:rgb(51, 51, 51);\\\"><div style=\\\"font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;background:white;\\\"><div style=\\\"font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;\\\"><div style=\\\"font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;background:rgb(255, 255, 255);line-height:1.8;overflow:hidden;\\\">\\\n\\\n\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;display:block;background:rgb(255, 255, 255);margin:0px;padding:0px;padding-bottom:15px;word-break:break-all;\\\">\\\nEXCEL工作表具有强大的功能，那么在EXCEL工作表中如何将含税金额换算为不含税金额呢？\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:15px 0px;\\\"><img src=\\\":/5bec6d8983d64a23867dd92c62eb050a\\\" type=\\\"image/png\\\" data-filename=\\\"t0177fc79fd5da07fea.png\\\" height=\\\"310\\\" style=\\\"font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);margin:0px;padding:0px;vertical-align:middle;border:none;max-width:100%;\\\" width=\\\"620\\\"/></div>\\\n\\\n</div>\\\n\\\n\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;display:block;background:rgb(255, 255, 255);margin:0px;padding:0px;padding-bottom:15px;word-break:break-all;\\\">\\\n<h2 style=\\\"border:0px;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;color:rgb(0, 0, 0);line-height:33px;margin-bottom:8px;font-weight:700;font-size:20px;\\\">材料/工具</h2>\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;line-height:30px;\\\">EXCEL</div>\\\n</div>\\\n\\\n\\\n\\\n<div style=\\\"font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;display:block;background:rgb(255, 255, 255);margin:0px;padding:0px;padding-bottom:15px;word-break:break-all;border-bottom:1px solid rgb(248, 248, 248);border:none;margin-bottom:0px;\\\">\\\n<h2 style=\\\"border:0px;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;color:rgb(0, 0, 0);line-height:33px;margin-bottom:8px;font-weight:700;font-size:20px;\\\">方法</h2>\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;\\\">\\\n<ul style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;list-style:none;margin:0px;padding:0px;\\\">\\\n<li style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;margin-bottom:10px;\\\">\\\n<span style=\\\"-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;border:0px;margin:0px;padding:0px;color:rgb(187, 187, 187);line-height:30px;font-size:15px;\\\"><span style=\\\"-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;border:0px;margin:0px;padding:0px;color:rgb(25, 185, 85);font-size:18px;\\\">1</span><i style=\\\"border:0px;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;font-weight:400;margin:0px;padding:0px;color:rgb(187, 187, 187);font-size:18px;font-style:normal;\\\">/</i>7</span>\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;\\\">\\\n如图，B列所列数据为含税金额，求得不含税金额结果在C列。<br style=\\\"margin:0px;padding:0px;\\\"/>\\\n</div>\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:15px 0px;\\\">\\\n<img src=\\\":/d3d207fef061472783b2dfed6ca0c786\\\" type=\\\"image/png\\\" data-filename=\\\"t01a30fa56f3b57190d.png\\\" height=\\\"302\\\" style=\\\"font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);margin:0px;padding:0px;vertical-align:middle;border:none;max-width:100%;\\\" width=\\\"620\\\"/>\\\n</div>\\\n\\\n</li>\\\n<li style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;margin-bottom:10px;\\\">\\\n<span style=\\\"-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;border:0px;margin:0px;padding:0px;color:rgb(187, 187, 187);line-height:30px;font-size:15px;\\\"><span style=\\\"-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;border:0px;margin:0px;padding:0px;color:rgb(25, 185, 85);font-size:18px;\\\">2</span><i style=\\\"border:0px;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;font-weight:400;margin:0px;padding:0px;color:rgb(187, 187, 187);font-size:18px;font-style:normal;\\\">/</i>7</span>\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;\\\">\\\n选中C2单元格，在单元格中输入函数“=”，点击【插入函数】。\\\n</div>\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:15px 0px;\\\">\\\n<img src=\\\":/05b0fc6469cb4ba887d63bf2c92cc803\\\" type=\\\"image/png\\\" data-filename=\\\"t0130a23e7f4e0da2e1.png\\\" height=\\\"306\\\" style=\\\"font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);margin:0px;padding:0px;vertical-align:middle;border:none;max-width:100%;\\\" width=\\\"620\\\"/>\\\n</div>\\\n</li>\\\n<li style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;margin-bottom:10px;\\\">\\\n<span style=\\\"-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;border:0px;margin:0px;padding:0px;color:rgb(187, 187, 187);line-height:30px;font-size:15px;\\\"><span style=\\\"-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;border:0px;margin:0px;padding:0px;color:rgb(25, 185, 85);font-size:18px;\\\">3</span><i style=\\\"border:0px;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;font-weight:400;margin:0px;padding:0px;color:rgb(187, 187, 187);font-size:18px;font-style:normal;\\\">/</i>7</span>\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;\\\">\\\n在弹窗中，将“或选择类别”选择为“全部”选项。\\\n</div>\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:15px 0px;\\\">\\\n<img src=\\\":/d51ab82c45984e57a5d48190e3f7f9d9\\\" type=\\\"image/png\\\" data-filename=\\\"t012e2f8f5b06c1e8a2.png\\\" height=\\\"310\\\" style=\\\"font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);margin:0px;padding:0px;vertical-align:middle;border:none;max-width:100%;\\\" width=\\\"620\\\"/>\\\n</div>\\\n\\\n</li>\\\n<li style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;margin-bottom:10px;\\\">\\\n<span style=\\\"-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;border:0px;margin:0px;padding:0px;color:rgb(187, 187, 187);line-height:30px;font-size:15px;\\\"><span style=\\\"-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;border:0px;margin:0px;padding:0px;color:rgb(25, 185, 85);font-size:18px;\\\">4</span><i style=\\\"border:0px;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;font-weight:400;margin:0px;padding:0px;color:rgb(187, 187, 187);font-size:18px;font-style:normal;\\\">/</i>7</span>\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;\\\">\\\n在选择函数中点击“ROUND”函数。\\\n</div>\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:15px 0px;\\\">\\\n<img src=\\\":/157d6aa83f9a43ada10e50a1d68aa64f\\\" type=\\\"image/png\\\" data-filename=\\\"t01f0417d806f5fc727.png\\\" height=\\\"304\\\" style=\\\"font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);margin:0px;padding:0px;vertical-align:middle;border:none;max-width:100%;\\\" width=\\\"620\\\"/>\\\n</div>\\\n</li>\\\n<li style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;margin-bottom:10px;\\\">\\\n<span style=\\\"-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;border:0px;margin:0px;padding:0px;color:rgb(187, 187, 187);line-height:30px;font-size:15px;\\\"><span style=\\\"-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;border:0px;margin:0px;padding:0px;color:rgb(25, 185, 85);font-size:18px;\\\">5</span><i style=\\\"border:0px;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;font-weight:400;margin:0px;padding:0px;color:rgb(187, 187, 187);font-size:18px;font-style:normal;\\\">/</i>7</span>\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;\\\">\\\n在弹窗中，第一行输入“B2/1.17”；第二行中输入数字“2”，表示至保留数字的两位数。设置好后点击【确定】。\\\n</div>\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:15px 0px;\\\">\\\n<img src=\\\":/476bc22054374d1f9725ed3bffba7c06\\\" type=\\\"image/png\\\" data-filename=\\\"t0155a12e0244a80b5b.png\\\" height=\\\"309\\\" style=\\\"font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);margin:0px;padding:0px;vertical-align:middle;border:none;max-width:100%;\\\" width=\\\"620\\\"/>\\\n</div>\\\n</li>\\\n<li style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;margin-bottom:10px;\\\">\\\n<span style=\\\"-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;border:0px;margin:0px;padding:0px;color:rgb(187, 187, 187);line-height:30px;font-size:15px;\\\"><span style=\\\"-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;border:0px;margin:0px;padding:0px;color:rgb(25, 185, 85);font-size:18px;\\\">6</span><i style=\\\"border:0px;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;font-weight:400;margin:0px;padding:0px;color:rgb(187, 187, 187);font-size:18px;font-style:normal;\\\">/</i>7</span>\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;\\\">\\\n如图，回到工作表可以看到，B2单元格的不含税金额已经出现在C2单元格了。\\\n</div>\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:15px 0px;\\\">\\\n<img src=\\\":/55f7e63bdfd847ad94d44049f2305863\\\" type=\\\"image/png\\\" data-filename=\\\"t013b2e5a94b27f2af4.png\\\" height=\\\"303\\\" style=\\\"font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);margin:0px;padding:0px;vertical-align:middle;border:none;max-width:100%;\\\" width=\\\"620\\\"/>\\\n</div>\\\n</li>\\\n<li style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;margin-bottom:0px;border-bottom:none;\\\">\\\n<span style=\\\"-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;border:0px;margin:0px;padding:0px;color:rgb(187, 187, 187);line-height:30px;font-size:15px;\\\"><span style=\\\"-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;border:0px;margin:0px;padding:0px;color:rgb(25, 185, 85);font-size:18px;\\\">7</span><i style=\\\"border:0px;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;font-weight:400;margin:0px;padding:0px;color:rgb(187, 187, 187);font-size:18px;font-style:normal;\\\">/</i>7</span>\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:0px;\\\">\\\n点击C2单元格，拖动鼠标，即可将所有不含税金额求出。\\\n</div>\\\n<div style=\\\"border:0px;font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;margin:0px;padding:15px 0px;\\\">\\\n<img src=\\\":/c843ceabc982475ebfce8ce148b818c7\\\" type=\\\"image/png\\\" data-filename=\\\"t01b50d39e4413b4245.png\\\" height=\\\"322\\\" style=\\\"font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);margin:0px;padding:0px;vertical-align:middle;border:none;max-width:100%;\\\" width=\\\"620\\\"/>\\\n</div>\\\n</li>\\\n</ul>\\\n</div>\\\n</div>\\\n<p style=\\\"-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;border:0px;margin:0px;padding:0px;color:rgb(153, 153, 153);line-height:20px;font-size:12px;\\\">\\\n<span style=\\\"font-size:100%;-webkit-tap-highlight-color:rgba(0, 0, 0, 0);vertical-align:baseline;border:0px;margin:0px;background:rgb(255, 240, 240);border-radius:2px;color:rgb(250, 80, 80);display:inline-block;margin-right:3px;padding:0px 4px;\\\">声明</span>\\\n\\\n\\\n\\\n\\\n本文系本人根据真实经历原创，未经许可，请勿转载。\\\n\\t\\t\\t\\\n\\\n\\\n\\\n</p>\\\n\\\n\\\n</div></div></div></div></div></div>\\\n</div>\\\n</span>\\\n</div></body></html>\\u0000\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":13084}]"
metadata_diff: {"new":{"id":"78fee93e7c44401992dd531c7879a32a","parent_id":"061de1401cfc4cfaadf6e74e015970e9","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":1764345718058,"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-28T16:12:39.448Z
created_time: 2025-11-28T16:12:39.448Z
type_: 13