testing for zero

M

Mike Lewis

Suzan,

=IF(AND(ISBLANK(F6)=FALSE,F6=0),1,0)

will work
-----Original Message-----
Hi

I need to be able to test a column for ones and then for
Click to expand...
zeroes and then add up each of the results. I did this for
the ones" if(k18=1,1) and it worked fine. But, if I do
this: if(k18=0,1) it gives me 1 for all the blank cells
also. I formated the cells to be numbers when it didn't
work, but that didn't help. What do I need to do? (this is
not my data; I would have laid it out much differently to
avoid this; I cannot sort because the sheet has merged
cells. *sigh*). Thanks in advance
 

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

Can't save my Office documents (after computer rebuild and reauthorization) 0
Need Help with a VBA subroutine 0
Testing a cell value for a specific weekday. 4
VBA Export to PDF 0
Multiple arguments 3
Nested IF Statements 6
Vlookup Returning Zero For Every Cell 3
Copy from one page to another 1

Top