View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
robzrob robzrob is offline
external usenet poster
 
Posts: 159
Default how to get the answers from 3 conditions

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'?