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!

IF Function Help
 

=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)),I F(F17=2, ...,
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:57
xdemechanik
---

IF Function Help
 

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

Matt



Needs Help wrote:
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!

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200809/1

IF Function 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!

"Needs Help" wrote:

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!

IF Function Help
 

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
---