Thread: are these 2 statements equivalent?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob O`Bob Bob O`Bob is offline
external usenet poster
  
Posts: 16
Default are these 2 statements equivalent?
Gary Keramidas wrote:
ok, is there a shorter way to write the first one?


this is no shorter, but IMO the intent is much more clear:

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



Bob
--
Reply With QuoteReply With Quote