how to get the answers from 3 conditions

  • Thread starter Thread starter Chiran
  • Start date Start date
C

Chiran

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????
 
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????
Click to expand...

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

In cell D1:

=OR(A1,B1)

Copy down - it will work for the example given.

HTH,
Bernie
MS Excel MVP
 
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 said:
Chiran,

In cell D1:

=OR(A1,B1)

Copy down - it will work for the example given.

HTH,
Bernie
MS Excel MVP


news:[email protected]...
Click to expand...
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
 
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
 
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
 
line C - 2 "f's" can't =T or
line D - 2 "f's" can't = F these two lines contradict each other.
 
Back
Top