1 2 3 4 Result
A True False False True
B False True False True
C False False True False
D False False False False
E True True True True


So i need to get the above result :(
But don't know the functions result???
Can any body help me plz????

On Jul 16, 12:27*pm, Chiran wrote:
1 * *2 * * * * 3 * * * * * * * * 4 * * * * * * * *Result
A *True *False *False * * * * * * *True
B * False * * * *True * False * * * * * * *True
C *False * * * * False *True * * * * * * * False
D *False * * False * * * *False * * * * * * *False
E *True * * *True * * * True * * * * * * * *True

So i need to get the above result :(
But don't know the functions result???
Can any body help me plz????

Do you mean that if there is one or more 'True' in a row then the
result should be 'True', otherwise 'False'?

1 2 3 4 Result
A True False False True
B False True False True
C False False True False
D False False False False
E True True True True


Do you mean that if there is one or more 'True' in a row then the
result should be 'True', otherwise 'False'?
No, the condition is like this if therer is true either in A2 or A3 then the
result should be true else false and if there is Ture or False in A4 then the
result should be False.
Can you help me plZ?

In your example there is always either True or False in column 4, so the
second part of your description doesn't make sense as the result would
always be False.

As with many questions on this group, it isn't really an Excel question, but
is a problem in defining the requirement. Until you can define the
question, you are going to struggle to get an answer.
[To bring it back into an Excel context, if you do get round to defining
your question at spme stage in the future, it will be less confusing if you
use Excel's convention of defining rows by numbers and columns by letters,
rather than vice versa.]
--
David Biddulph

"Chiran" wrote in message
...
1 2 3 4 Result
A True False False True
B False True False True
C False False True False
D False False False False
E True True True True


Do you mean that if there is one or more 'True' in a row then the
result should be 'True', otherwise 'False'?
No, the condition is like this if therer is true either in A2 or A3 then
the
result should be true else false and if there is Ture or False in A4 then
the
result should be False.
Can you help me plZ?

Sorry for all my mistakes

But actually i need the answer as it has been mentioned in the result sections


A B C D Result
1 True False False True
2 False True False True
3 False False True False
4 False False False False
5 True True True True


Do you mean that if there is one or more 'True' in a row then the
result should be 'True', otherwise 'False'?
No, the condition is like this if therer is true either in A2 or A3 then
the
result should be true else false and if there is Ture or False in A4 then
the
result should be False.
Can you help me plZ?

Chiran,

In cell D1:

=OR(A1,B1)

Copy down - it will work for the example given.

HTH,
Bernie
MS Excel MVP


"Chiran" wrote in message
...
1 2 3 4 Result
A True False False True
B False True False True
C False False True False
D False False False False
E True True True True


So i need to get the above result :(
But don't know the functions result???
Can any body help me plz????

Thanks for the reply but still my problem is not solved? It says Valued only??
Can you plz send me more the solutions.
1 2 3 4 Result
A True False False True
B False True False True
C False False True False
D False False False False
E True True True True

Can you plz make some conditions so that i can get the above result.

"Bernie Deitrick" wrote:

Chiran,

In cell D1:

=OR(A1,B1)

Copy down - it will work for the example given.

HTH,
Bernie
MS Excel MVP


"Chiran" wrote in message
...
1 2 3 4 Result
A True False False True
B False True False True
C False False True False
D False False False False
E True True True True


So i need to get the above result :(
But don't know the functions result???
Can any body help me plz????

Chiran,

You possibly don't have TRUE and FALSE values, but the strings "True" and "False".

Try this in D1:

=OR(A1="True",B1="True")

HTH,
Bernie
MS Excel MVP


"Chiran" wrote in message
...
Thanks for the reply but still my problem is not solved? It says Valued only??
Can you plz send me more the solutions.
1 2 3 4 Result
A True False False True
B False True False True
C False False True False
D False False False False
E True True True True

Can you plz make some conditions so that i can get the above result.

"Bernie Deitrick" wrote:

Chiran,

In cell D1:

=OR(A1,B1)

Copy down - it will work for the example given.

HTH,
Bernie
MS Excel MVP


"Chiran" wrote in message
...
1 2 3 4 Result
A True False False True
B False True False True
C False False True False
D False False False False
E True True True True


So i need to get the above result :(
But don't know the functions result???
Can any body help me plz????

line C - 2 "f's" can't =T or
line D - 2 "f's" can't = F these two lines contradict each other.

"Chiran" wrote:

1 2 3 4 Result
A True False False True
B False True False True
C False False True False
D False False False False
E True True True True


So i need to get the above result :(
But don't know the functions result???
Can any body help me plz????