有没有办法在Excel中找到最大的小数位数 [英] Is there a way to find the largest number of decimal places in an Excel

问题描述

我在 Excel 中有一张工作表，其中包含许多不同小数位的数字.我试图在 MySQL 中创建一个表来尽可能有效地存储这些数据，但我需要知道每列中的最高小数位数.有没有我可以用来解决这个问题的函数?

I have a sheet in Excel which contains a lot of numbers to varying decimal places. I'm trying to create a table in MySQL to store this data as efficiently as possible, but I need to know the highest number of decimal places in each column. Is there a function which I can use to work this out?

我的数据集如下所示:

Item | Val 1 | Val 2 | Val 3
=====|=======|=======|=======
1    | x.xxx | x.xx  | xx.xx
...  | x.xx  | x.x   | xx.xxx
n    | xx.x  | x.xx  | xx.xx

例如，在 Val 1 列中，最高小数位数是 3.但是，考虑到完整数据集的庞大规模，我很难手动遍历每一列并计算出最高的小数位数小数点.

For example, in the Val 1 column, the highest number of decimal places is 3. Given the sheer size of the full dataset, however, it would be difficult for me to manually go through every column and count the highest number of decimal places.

推荐答案

也许可以帮到你.这是一个excel公式.

May be it can help you. It is an excel formula.

=MAX(LEN(MID(B2:B5,SEARCH(".",B2:B5)+1,LEN(B2:B5)-SEARCH(".",B2:B5))))

按Ctrl+Shift+回车，因为它是一个数组公式.

Press Ctrl+Shift+Enter as it is an array formula.

这篇关于有没有办法在Excel中找到最大的小数位数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！