View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default And Question, (a&b, or just a)

Hi, I am trying to save some space, ~30% 1 column, cant tell if there is a
short way. short example:

=IF(S9="","",IF(X1="c",AND(AND(A1="a",B1="b"),AND( C1="c",D1="d")),AND(A1="a",B1="b")))

if x=1, then part a & b, otherwise, just a. This works, but can't see how
to just do with 2 parts, stead of part a repeated twice. just cannot see
it... Thanks