Forum Discussion
Solved
QUESTION ABOUT EXCEL
For date from> = 08/20/1950 to display the value 80 and for date> = 09/20/1950 to <= 10/30/1998 to display the value 60 and for date> = 10/31/1998 to and <= 01/30/2008 to display the value 60! I appl...
Here is the sample workbook.
For date from
1. <= 20/08/1950 to display the value 80 points and
2. for date> = 20/09/1950 until <= 30/10/1998 to display the value 60 points and
3. for date> = 31/10/1998 until <= 30/01/2008 to display the value 40 points
Which way is the best to find the solution ?
1. <= 20/08/1950 to display the value 80 points and
2. for date> = 20/09/1950 until <= 30/10/1998 to display the value 60 points and
3. for date> = 31/10/1998 until <= 30/01/2008 to display the value 40 points
Which way is the best to find the solution ?
- Is about some deadlines !
My problem is that I cannot find the right functions about that!With the information that you have provided:
=IF(C2<=DATE(1950,8,20), 80, IF(C2<=DATE(1950,9,19), "Undefined", IF(C2<=DATE(1998,10,30), 60, IF(C2<=DATE(2008,01,30), 0, "Undefined"))))
where C2 is the cell with the date.