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.....

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" <sunder wrote in message
...
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.....

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
...
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" <sunder wrote in message
...
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.....