return 0 if cell has data?
in [Functions]
|
From: kathysonisland on 9 Apr 2010 13:05 I feel stupid asking this question.......I just cannot figure a formula out that I know I know......... I need a formula to display 0 in a cell if another cell has a date.
From: Dulanic on 9 Apr 2010 13:14 kathysonisland;695107 Wrote: > I feel stupid asking this question.......I just cannot figure a formula out > that I know I know......... > > I need a formula to display 0 in a cell if another cell has a date. Can the cell only be a date? If so... =IF(E3>0,0,"") -- Dulanic ------------------------------------------------------------------------ Dulanic's Profile: 1734 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=194407 http://www.thecodecage.com/forumz
|
Pages: 1 Prev: How do I truncate linked text? Next: Counting Merged Cells |