Thread: are these 2 statements equivalent?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default are these 2 statements equivalent?
Nope.

Put False in all those cells and look how each formula evaluates.

Gary Keramidas wrote:

=AND(H2=T2,T2=T4,T4=T6,T6=W8,H21=H2)
=AND(H2,T2,T4,T6,W8 =H21)

--

Gary

--

Dave Peterson
Reply With QuoteReply With Quote