Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
Return an empty cell | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions |