是Excel中类似的命令，其执行与MATLAB中的"floor"命令相同 [英] Is the a similar command within Excel that performs the same as the 'floor' command within MATLAB

问题描述

MATLAB中的"floor"命令定义为朝负无穷大舍入. floor(X)将X的元素四舍五入到最接近的整数 朝向负无穷大."

The 'floor' command in MATLAB is defined as "Round towards minus infinity. floor(X) rounds the elements of X to the nearest integers towards minus infinity."

Excel中是否有类似的命令，或者有人知道如何在Excel中执行相同的操作吗?

Is there a similar command within Excel, or does anyone know how to perform the same action within Excel?

推荐答案

是的，您可以使用=INT(A1)公式.它将一个数字(从A1单元格四舍五入)到最接近的整数.这是文档.

yes, you can use =INT(A1) formula. It rounds a number (from A1 cell) down to the nearest integer. Here is documentation.

这篇关于是Excel中类似的命令，其执行与MATLAB中的"floor"命令相同的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！