forrestgump
New Member
- Joined
- Sep 30, 2010
- Messages
- 22
Hi There, Not sure if this is possible but can I create a formula that if cell A1 is blank b1 = 'No Owner' but if the cell is not blank b1 would have to = 'In progress' or 'completed'?
Hi There, Not sure if this is possible but can I create a formula that if cell A1 is blank b1 = 'No Owner' but if the cell is not blank b1 would have to = 'In progress' or 'completed'?
Does this work:
=IF(A1="","No Owner","In progress or completed")
I hope this helps!
=IF(A1="","'No Owner'","'In progress' or 'completed'")