本文介绍了将小数点后的数字增加到小于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?
发布评论