kmlynn1010
Board Regular
- Joined
- Feb 8, 2005
- Messages
- 95
Hello!!
So, I'm trying to say that when a1, b1, and c1 are all 0, enter today's date in d1. This is what I have so far:
=IF(AND(CJ6=0,CN6=0,CR6=0),"now"," ")
I've tried
=IF(AND(CJ6=0,CN6=0,CR6=0),=now," ")
=IF(AND(CJ6=0,CN6=0,CR6=0))=now," "
=IF(AND(CJ6=0,CN6=0,CR6=0),date," ")
=IF(AND(CJ6=0,CN6=0,CR6=0),=date," ")
I'm so clueless!
So, I'm trying to say that when a1, b1, and c1 are all 0, enter today's date in d1. This is what I have so far:
=IF(AND(CJ6=0,CN6=0,CR6=0),"now"," ")
I've tried
=IF(AND(CJ6=0,CN6=0,CR6=0),=now," ")
=IF(AND(CJ6=0,CN6=0,CR6=0))=now," "
=IF(AND(CJ6=0,CN6=0,CR6=0),date," ")
=IF(AND(CJ6=0,CN6=0,CR6=0),=date," ")
I'm so clueless!