asked on Array formula result will not display
Hi.
i hae this formula
=PERCENTILE.EXC(IF(OR(Test
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
i hae this formula
=PERCENTILE.EXC(IF(OR(Test
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
Microsoft Excel
Last Comment
Seamus2626
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
Thanks
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hey guys, it was a case of saving down my excel ss somewhere else, one of those excel things, all good now
thanks
thanks
Im not sure why its displaying as zero