Hi All,
I want to create an “if” function that would calculate only if cell A1 is non blank & B1 is non blank.
How can I define cells that has a value? (I don’t need to count the blank cells-I need to calculate non blank cells)
Thanks in advance,
Hi All,
I want to create an “if” function that would calculate only if cell A1 is non blank & B1 is non blank.
How can I define cells that has a value? (I don’t need to count the blank cells-I need to calculate non blank cells)
Thanks in advance,
Your requirement is not very clear, but maybe this is what you want...
=IF(AND(A1<>"",B1<>""),"Meets criteria","Does not meet criteria")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks