将小数点后的数字增加到小于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屋！