I’m trying to calculate the lower quartile of a range of values, but the cell value is always #NAME?
Here is the code:
Cell cell = ws.Cells[0, 0];
cell.Formula = “=PERCENTILE(A2:A10, 0.25)”;
decimal decLQ = Convert.ToDecimal(cell.Value);
I also tried R1C1Formula but got the same result. If I paste the formula directly into the cell in the spreadsheet in Excel, it’s fine. Other functions such as AVERAGE, MIN, MAX are ok.
Why won’t it work?
Thanks for considering Aspose.
Well, PERCENTILE Function is not supported by Aspose.Cells calculation engine, we will support it soon for your need.
Please try this attached version. We support Percentile function now.