Array formula result will not display
Posted on 2013-11-13
i hae this formula
=PERCENTILE.EXC(IF(OR(Testing=1,Testing=3,Testing=4,Testing=5,Testing=6),CashFormula),'S7 - Product Risk Scenario'!D28)
The result in the formula bar is 4,511,758,955
in the cell, 0 appears.
There is also the error message "Excel ran out of resources while attempting to calculate one or more formulas. As a result these formulas cannot be evaluated"
But if i was to put in a vlookup, it would return a result.
Can someone share some thoughts?