Very strange problem, is this a bug?

[excelos]

Hello!

These two functions seem identical to me:

=IF(D46<$J8,IF(D29=0,IF(D30=0,0,"BOTTLENECK"),D29/($J8-COLUMNS($D49:D49))),0)
=IF(D46<$J9,IF(D32=0,IF(D33=0,0,"BOTTLENECK"),D32/($J9-COLUMNS($D50:D50))),0)

The input cells are exactly the same, D29=0 and D30=431 with the only difference being $J8 being 28 and $J9 being 30.

However, the second function delivers inconsistent results with the first one.

Any idea what could be wrong?

 

[RoryA]

Re: Very strage problem, is this a bug?

You haven't given enough information. What is in D32, D33 for example? How are the results inconsistent?

 

[excelos]

Re: Very strage problem, is this a bug?

To make it more simple, this is the formula:

=IF(G32=0,IF(G33=0,0,"BOTTLENECK"),G32/($J9-COLUMNS($D50:G50)))

G32=0
G33=431
$J9=30

yet, instead of showing BOTTLENECK, it shows 0!

That's so strange, can anyone identify what's wrong?

 

[navic]

Re: Very strage problem, is this a bug?

These two functions seem identical to me:
Any idea what could be wrong?

Yes but the criterion is different in D33 cell.
Put some value in the D33 cell as 7 or 431 so see the result.

 

[Peter_SSs]

Re: Very strage problem, is this a bug?

=IF(G32=0,IF(G33=0,0,"BOTTLENECK"),G32/($J9-COLUMNS($D50:G50)))

G32=0
G33=431
$J9=30

yet, instead of showing BOTTLENECK, it shows 0!

One way that could happen is if cell G32 is holding a Text 0 instead of a Numerical 0

 

[steve the fish]

Re: Very strage problem, is this a bug?

Id imagine this also returns FALSE:

=ISNUMBER(G32)

 

[RoryA]

Re: Very strage problem, is this a bug?

Or calculation is set to manual.

 

[excelos]

Re: Very strage problem, is this a bug?

Id imagine this also returns FALSE:

=ISNUMBER(G32)

It actually returns TRUE!

 

[excelos]

Re: Very strage problem, is this a bug?

Or calculation is set to manual.

How do I check that?

 

[excelos]

Re: Very strage problem, is this a bug?

Yes but the criterion is different in D33 cell.
Put some value in the D33 cell as 7 or 431 so see the result.

I put it and it doesn't change anything!

Is there a way to upload the file to check?