要添加多少X个单元格以达到Y％ [英] How many X cells to add to reach Y%

问题描述

我正在处理此问题： https://tempfile.me/download/nYhdQHD65GxRzk/ 。

I'm working on this: https://tempfile.me/download/nYhdQHD65GxRzk/ .

我需要计算应该将多少 1 单元格添加到A列， code> 1 s = 85％。

And I need to count how many 1 cells should be added to column A to reach a percentage of 1s = 85%.

这只是一个例子，我不能添加<$ c $

This is just an example, I can't add cells with 1 and see how many of them I need since it should be automated on a big sample of data.

推荐答案

表示为：

.85(count + x) = sum + x

这会转换为x =（（85 x count） - （100 x sum））/（100 - 85） / p>

this renders down to x = ( (85 x count) - (100 x sum) ) / (100 - 85) or,

=(85*COUNT(A:A)-100*SUM(A:A))/(100-85) 

但是，这不会导致整数，因此要确保达到85％：<​​/ p>

However, this does not result in an integer, so to ensure 85% is reached:

=ROUNDUP((85*COUNT(A:A)-100*SUM(A:A))/(100-85),0)  

添加为 1时的结果（234） s将TRUE总计增加到284，并将所有条目的计数增加到334，其中284/334是85.03％。

The result (234) when added as 1s increases the TRUE total to 284 and the count of all entries to 334, where 284/334 is 85.03%.

这篇关于要添加多少X个单元格以达到Y％的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！