From: sunder jangra sunder on 1 Apr 2010 22:39 if column A1 has any value and column A3 has any value and column A7 has any value , so can i short these value with excel formula..... From: Fred Smith on 1 Apr 2010 22:55 You'll need to provide a clearer explanation of what you are looking for. A1, A3 and A7 are cells, not columns. What does "short these" mean? Do you mean "show these"? If so, is this what you are looking for: =if(and(a1<>"",a3<>"",a7<>""),true,false) Regards, Fred Best idea is to provide an example of what you want done. Regards, Fred "sunder jangra" wrote in message news:07548336-91D1-4BC0-B470-A73447182334(a)microsoft.com...> if column A1 has any value and column A3 has any value and column A7 has > any > value , so can i short these value with excel formula..... From: "David Biddulph" groups [at] on 2 Apr 2010 03:32 Or, if you are happy with Fred's interpretation, you can replace his IF formula by just =and(a1<>"",a3<>"",a7<>"") as the AND function returns TRUE or FALSE. -- David Biddulph "Fred Smith" wrote in message news:urbu3\$g0KHA.4832(a)TK2MSFTNGP04.phx.gbl...> You'll need to provide a clearer explanation of what you are looking for. > A1, A3 and A7 are cells, not columns. What does "short these" mean? > > Do you mean "show these"? If so, is this what you are looking for: > =if(and(a1<>"",a3<>"",a7<>""),true,false) > > Regards, > Fred > > Best idea is to provide an example of what you want done. > > Regards, > Fred > > "sunder jangra" wrote in message > news:07548336-91D1-4BC0-B470-A73447182334(a)microsoft.com... >> if column A1 has any value and column A3 has any value and column A7 has >> any >> value , so can i short these value with excel formula..... >  |