Thread: modifying this formula to return an empty cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Outbacker Outbacker is offline
external usenet poster
  
Posts: 10
Default modifying this formula to return an empty cell
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.
Reply With QuoteReply With Quote