can i short data with excel formula

  • Thread starter Thread starter sunder jangra
  • Start date Start date
S

sunder jangra

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top