PDA

View Full Version : Multiple If statements with multiple date range



jaaakez99
04-30-2010, 09:28 AM
Trying to combine the following if statements into one so that the letter corresponding to the date range will display in the cell. Any suggestions?

=IF(OR(TODAY()>=E4,TODAY()<=F4),"E")
=IF(OR(TODAY()>=F4,TODAY()<=G4),"F")
=IF(OR(TODAY()>=G4,TODAY()<=H4),"G")
=IF(OR(TODAY()>=H4,TODAY()<=I4),"H")

Bob Phillips
04-30-2010, 09:31 AM
Brte force

=IF(OR(TODAY()>=E4,TODAY()<=F4),"E",IF(OR(TODAY()>=F4,TODAY()<=G4),"F",IF(OR(TODAY()>=G4,TODAY()<=H4),"G",IF(OR(TODAY()>=H4,TODAY()<=I4),"H",""))))

jaaakez99
04-30-2010, 09:36 AM
that worked, thank you! Is there a way though, to make it so the letter for the most current date appears?

Bob Phillips
04-30-2010, 09:42 AM
Can you explain that a bit more, perhaps with an example?

jaaakez99
04-30-2010, 09:46 AM
I have attached the file. I am new at this, so let me know if this isnt what you wanted. Thanks again.

Bob Phillips
04-30-2010, 10:13 AM
Try

=INDEX(D1:M1,1,MATCH(TODAY(),D2:M2,1))

jaaakez99
04-30-2010, 10:15 AM
that worked, thank you!