View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ken Ken is offline
external usenet poster
 
Posts: 207
Default are these 2 statements equivalent?

Gary

It is a little shorter, and I think a lttle clearer to just go with

=h2=t2=t4=t6=w8=h21

since it looks to me like you want TRUE if those cells are all the same
and FALSE otherwise.

Ken


Gary Keramidas wrote:
=AND(H2=T2,T2=T4,T4=T6,T6=W8,H21=H2)
=AND(H2,T2,T4,T6,W8 =H21)


--


Gary