VBA中的百分位数公式错误 [英] percentile formula error in VBA

问题描述

我正在尝试通过VBA在特定范围内应用公式.这是我的VBA编辑器中的代码:

I'm trying to apply a formula through VBA for a particular range. This is the code in my VBA editor:

Sheets("WBR45").Range("AE105").Formula = "=PERCENTILE.INC(TP!$A$3:$A$30:$B$3:$B$30:$C$3:$C$30:$E$3:$E$30,50%)*24"

运行时，以下公式将在目标单元格中​​更新:

And the below formula gets updated in the destination cell when this is run:

=PERCENTILE.INC(TP!$A$3:$A$30:$B$3:$B$30:$C$3:$C$30:$E$3:$E$30,50%)*24

但是我在目标单元格中​​收到一个错误，显示为#VALUE！.

But I get an error in the destination cell as #VALUE!.

当我单击显示计算步骤"时，只有公式的这一部分带有下划线:

And when I click on "Show Calculation steps", only this part of the formula is underlined :

TP!$A$3:$A$30:$B$3:$B$30

我不知道这个简单的公式有什么问题.有人可以看看吗

I have no idea what is wrong with this simple formula. Can someone please take a look

推荐答案

老实说，我不知道您在做什么，但这可能会解决:

Honestly I have no clue about what you're doing with this, but this may fix it:

"=PERCENTILE.INC(TP!$A$3:$A$30:TP!$B$3:$B$30:TP!$C$3:$C$30:TP!$E$3:$E$30,50%)*24"

这篇关于VBA中的百分位数公式错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！