Function argument correct result but answer 0 in cell?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tonzie - 17 Mar 2008 04:04 GMT

Can anyone explain why I get the correct answer in the Function argument but
0 (Zero) displayed as the result in the Cell. I have an idea it could be
something in the options

Reply to this Message

Tyro - 17 Mar 2008 04:45 GMT

I have no idea either. You didn't provide the data in the cells, the
function you're using and where you are using the function. My mind is tired
tonight. No mind reading possible.

Tyro

> Can anyone explain why I get the correct answer in the Function argument
> but
> 0 (Zero) displayed as the result in the Cell. I have an idea it could be
> something in the options

Reply to this Message

Ron Rosenfeld - 17 Mar 2008 12:52 GMT

>Can anyone explain why I get the correct answer in the Function argument but
>0 (Zero) displayed as the result in the Cell.

Yes, someone can explain that.

>I have an idea it could be something in the options

It might be. Hard to tell based on the information you've provided so far.
--ron

Reply to this Message

Max - 17 Mar 2008 14:06 GMT

My guess is that it is an array formula which just needs to be
"array-entered", ie try clicking inside the formula bar, then press
CTRL+SHIFT+ENTER to confirm the formula (instead of just pressing ENTER).

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Can anyone explain why I get the correct answer in the Function argument but
> 0 (Zero) displayed as the result in the Cell. I have an idea it could be
> something in the options

Reply to this Message