natasha_tracy
New Member
- Joined
- Aug 20, 2007
- Messages
- 49
I am trying to do a statement that says,
If cell A1 AND A2 are blank, then $0 else...
I know what the else forumla is, but I can't work out how to do the IF A1 AND A2 are blank. I can do it if it's only A1 that's blank, but I only want it to return $0 if both A1 and A2 are blank.
Can anyone help please?
If cell A1 AND A2 are blank, then $0 else...
I know what the else forumla is, but I can't work out how to do the IF A1 AND A2 are blank. I can do it if it's only A1 that's blank, but I only want it to return $0 if both A1 and A2 are blank.
Can anyone help please?