View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default use "if" formula???

On Fri, 2 Jan 2009 10:17:01 -0800, taurus99
wrote:

How do I get cell E to return PASS OR FAIL, if any the cells A1:AD equal TRUE?

A B C D E
TRUE FALSE TRUE FALSE FAIL



Assuming AD should be read as D1 you may try this in cell E1:

=IF(AND(A1:D1),"PASS","FAIL")

Hope this helps / Lars-Åke