Start Free Trial

asked on

Array formula result will not display

Hi.

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?
#
Thanks

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

I have ssaqibh,

Im not sure why its displaying as zero

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

If i go up to the formula bar and click Fx, the Function Arguments show me the results, and the result is valid and returns "4,511,758,955"

Thanks

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

Hey guys, it was a case of saving down my excel ss somewhere else, one of those excel things, all good now

thanks