View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Needs Help Needs Help is offline
external usenet poster
 
Posts: 9
Default IF Function Help

I am trying to create an IF function for a spreadsheet. What I want the IF
statement to do is to look at a column, and depending on what is in the
column, return a date. This is what I have so far, but I cannot get it to
work when I add more IF statements to the formula:

=IF(F17,"1",DATE(YEAR(B17),MONTH(B17)+12,DAY(B17)) . What I want to add is IF
F17,"2",DATE..... I want to be able to do this several more times in the same
statement. Please help.

Thank you!