How to you count cells that contain any entry?

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

Guest

=IF(J9="x",1,IF(K9="x",1.5,IF(L9="x",2,IF(M9="x",2.5,IF(N9="x",3,IF(O9="x",3.5,IF(P9="x",4,"")))))))

This works fine for me if my customers use an x, but some use a tick or a
star, or any computer letter/symbol.
Can this equation be made to work irrespective of what the entry in the cell
is?
 
=IF(J9<>"", 1, etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Value part of formula exlusion/ Not affects neg's: value 2
Type Mismatch problem... 3
Formula to compare multiple cells 7
Not allowing users to enter data into certain cells if another cell is empty 12
How to lock a cell value when values going into that cell keep changing... 5
how to skip over cells during entry? 1
How to explain??... 2
How to count blank cells that contain formula? 5

Back
Top