check for two blank cells before populating a 3rd.
I'm trying to do a chart using dates. I would like to set it so that if A1,
or B1 is blank, then C1 is also blank. If BOTH A1 and B1 contain information,
then C1 = A1 + 1.
I have tried this, and it doesn't work.
=IF(AND(ISBLANK($A1)),(ISBLANK(B1))),"",($A1)+1
I have also tried a few other things, all of which don't work.
Any help would be greatly appreciated.
|