Dec 09 2021 12:53 PM
Dec 09 2021 12:58 PM
why 8/20/1950 and 9/20/1950?
Why twice the value 60?
Try a variation of this, where C2 is the cell with the date:
=IF(C2<=DATE(1950,9,20),80,IF(C2<=DATE(1998,10,30),70,IF(C2<=DATE(2008,01,30),60,"?")))
Dec 09 2021 01:13 PM
Dec 09 2021 01:15 PM
Dec 09 2021 01:16 PM
Dec 09 2021 01:22 PM
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.
Dec 09 2021 01:22 PM - edited Dec 09 2021 01:24 PM
@emmapapa2 .... It is unclear what the problem is. Is it simply that DATEVALUE does not work for you? If so, what does it return? Or is that your logic does not work for you? If so, what exactly are the formulas that you tried?
The problem might be that the form of the dates is not recognized as numeric dates; instead, Excel might be treating them as text. Use formulas like =ISNUMBER(A1) to determine the type of the data.
If you are still having a problem, I suggest that you attach an Excel file (not an image) that demonstrates the problem
Dec 09 2021 01:36 PM
Dec 09 2021 01:56 PM
I'd create a small lookup table. In the screenshot below, it is on the same sheet, but it can be on another sheet if you prefer.
Formula in Y5:
=VLOOKUP(X5,$AC$5:$AD$11,2)
Dec 09 2021 02:00 PM
Dec 09 2021 02:03 PM
SolutionHere is the sample workbook.
Dec 09 2021 02:21 PM
@Hans Vogelaar last question! COULD YOU HELP ME???
Dec 09 2021 02:57 PM
See the attached sample workbook.
Dec 09 2021 03:06 PM
Dec 10 2021 12:30 AM
The sample workbook that I attached already returns K(x3) for all regions...
Dec 10 2021 12:41 AM
Dec 10 2021 02:51 AM
Dec 09 2021 02:03 PM
Solution