data in cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to look through a range of cells (A1:z1) and if any one of the cells
is not blank I would like to return a 1.

Thanks
Ron
 
Your formula returns a value if any one cell is blank, I need it to return a
vlaue is any on cell is not blank.
 
Oh, my apologies. Maybe you can try this then ...

=IF(COUNTA(A1:Z1),1,0)
 
You must log in or register to reply here.

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

Similar Threads

ME, STRANGE SUMMATION 3
Concatenate a row that is selected and include blank cells 11
Conditional formating -identify blank cell 3
Adjusting formulas by copying across cells w/o changing the refere 6
Excel Need Countifs Formula Help 0
DisplayedText? 2
Remove punctuation mark, Split cells & average accross column 4
Comparison of columns using Conditional Formatting 3

Back
Top