#VALUE! instead of Boolean value

[Robin Clay]

Greetings !

I have this :

A B
1 0 =A1>0
2 0 =A2>0
3 1 =A3>0
4
5 =OR(B1, B2, B3)

And this SHOULD show

A B
1 0 FALSE
2 0 FALSE
3 1 TRUE
4
5 TRUE

and when I try it in a new sheet, that's what I get.

But in the far more complicated sheet where I want it,
I get those three values in Column B alright, BUT

Cell B5 generates #VALUE!


(1) Why ???
(2) How can I get it to give the correct value ?


RClay AT haswell DOT com

 

[Frank Kabel]

Hi Robin
this works for me. Have you used exactly the same formulas on your
'complicated' sheet?