Hello,
I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell will read U16, but if the date is between 01/01/1996 and 31/12/1997 it will read U14 and if the date is later than 01/01/1998, it will read U12.
Thanks for any help.
Configuration: Windows XP Firefox 3.5.2
Your date entry is in A1
|
"else if excel 2003" Add calculations to if function in excel Adjusted trial balances in excel 2007 if function Changing date format in excel 2003 Conditional formatting excel 2003 if no. max Excel 2007 if cell equals another cell then show value of cell beside it Excel cell if statement test text for value Excel conversion date text to column Excel find if a date is between two dates or blank cell Excel format date text Excel formula if text on one list is found on another list Excel formulas if combined with find , left text Excel query-if a variable has value 3 then next 3 row will take value a.how to do by excel function If function excel 2003 color If i have excel 2007 and receive a file that is excel 2003, how can i open the file in excel 2003? If then else in excel 2003 If,and function excel 2003 Reference a cell in another spreadsheet in excel 2003