填报round函数计算精度不正确

1. 概述

1.1 问题描述

在填报场景中使用round函数计算时,可能会出现数字的精度问题,例如公式=round(1.9999,2)的页面显示计算结果为2,但是在填报入库时,填入的却是1.9999。

1.2 原因分析

在小数位较多的情况下,round函数如果只有2个参数的话,会有精度不准确的问题,需要添加第三个参数true来解决。

2. 解决方案

添加第三个参数true,就可以解决填报时精度不准确的问题。例如:=round(1.9999,2,true)

Attachment List


Theme: 下架文档
Already the First
Already the Last
  • Helpful
  • Not helpful
  • Only read

滑鼠選中內容,快速回饋問題

滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

不再提示

10s後關閉

Get
Help
Online Support
Professional technical support is provided to quickly help you solve problems.
Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
Page Feedback
You can provide suggestions and feedback for the current web page.
Pre-Sales Consultation
Business Consultation
Business: international@fanruan.com
Support: support@fanruan.com
Page Feedback
*Problem Type
Cannot be empty
Problem Description
0/1000
Cannot be empty

Submitted successfully

Network busy