根据小于 100 的小数增加数字? [英] Increasing a number based on a decimal less than 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))

这篇关于根据小于 100 的小数增加数字?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！