将小数点后的数字增加到小于100?

本文介绍了将小数点后的数字增加到小于100?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我目前正在研究一些SUMIF公式，这些公式将针对特定条件计算某些值.所有要计算的值均以十进制表示，但基于0.80 = 1.00.

I'm currently working on some SUMIF formulae which will calculate certain values against specific conditions. All of the values to be calculated are decimalised but are based on 0.80 = 1.00.

例如，如果我将1.25和1.60加在一起，我希望结果读取为3.05，但目前，我将得到2.85的结果.

As an example if I have 1.25 and 1.60 to add together I would want the outcome to read 3.05 but currently, I would get an outcome of 2.85.

是否有可能在将小数转换为1之前修改小数可以读取的最高数字?

Is it possible to amend the highest number a decimal can read before it converts to 1?

希望这是有道理的.

推荐答案

尝试:

=ARRAYFORMULA(SUM(QUOTIENT(D1:D3, 1))+ QUOTIENT(SUM(MOD(D1:D3, 1)), 0.8)+ MOD(SUM(MOD(D1:D3, 1)), 0.8))