IF Function Help

[Needs 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!

 

[Max]

=IF(F17,"1",DATE(YEAR(B17),MONTH(B17)+12,DAY(B17))

From your sample formula above,
believe you probably meant to do something like this
=IF(F17=1,DATE(YEAR(B17),MONTH(B17)+12,DAY(B17)),IF(F17=2, ...,
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:57
xdemechanik
---

 

[Mattlynn via OfficeKB.com]

Hi - i believe that 6 IF statements is the max for any one formula

Matt

 

[Needs Help]

I was able to figure out the formula. I do have another question. I have a
column filled with dates. I want to be able to create a formula that pulls
the most recent date to show in a different cell. How would I do that.

Lets say I have in column H:
9/21/08
10/02/08
01/26/09
6/26/09

I want to be able to have the most recent date (6/26/09) show in cell A1.

Thanks!

 

[Max]

Pl take a moment to press the "Yes" buttons in all responses which helped

As for your new question:

.. a formula that pulls the most recent date to show in a different cell

In A1: =MAX(H:H)
where col H contains real dates

Real dates in Excel are just numbers,
hence MAX returns the largest, ie the most recent date
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:57
xdemechanik
---