the formula is
=IF(OR(A1="company1",A1="company2"),B1+3,IF(OR(A1="company3",A1="company4"),B1+5,B1+30))
the B column of my spreadsheet contains dates. the problem is, if there is
no date in the B column, this formula returns 1/5/1900. what could i add at
the end of this formula so that it leaves the cell blank if there is no date
in column B. thanks in advance.
Bookmarks