I have cells A1 & B1. I want a formula in C1 to do the following:
If A1 and B1 are both not blank, then No
But ... If A1 is not blank and B1 is, then Yes
I can't figure out the formula to use! Any help?
I have cells A1 & B1. I want a formula in C1 to do the following:
If A1 and B1 are both not blank, then No
But ... If A1 is not blank and B1 is, then Yes
I can't figure out the formula to use! Any help?
Something like this?
=IF(AND(A1<>"",B1<>""),"No","Yes")
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
=if(and(A1<>"",B1<>""),"No",if(and(A1<>"",B1=""),"Yes","?")
I put a question mark in for any conditions you did not specify (for example, what if both are blank?)
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks