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.
Construction age (x5):
The time period in which the date of issuance of the building permit is included is stated. In case of addition of a permit and / or inclusion in a law of arbitrary settlement, the declaration is made on the basis of the period of issuance of the initial building permit. In case there is no building permit, the construction declaration is made on the basis of being subject to an arbitrary settlement law.
For the dates of issuance of a permit / construction based on a declaration of affiliation, the scoring is as follows:
(x5≤09.08.1955) = 100 points,
(10.08.1955≤ x5≤09.06.1975) = 80 points,
(10.06.1975≤ x5≤31.12.1982) = 60 points,
(01.01.1983≤ x5≤31.12.1992) = 45 points,
(01.01.1993≤ x5≤31.12.2003) = 30 points,
(01.01.2004≤ x5≤31.12.2011) = 15 points
(x5> 1.1.2012) = 0 points
The real problem is this! And I would like to introduce a functions tofind thw solution! Could you helpme???
The time period in which the date of issuance of the building permit is included is stated. In case of addition of a permit and / or inclusion in a law of arbitrary settlement, the declaration is made on the basis of the period of issuance of the initial building permit. In case there is no building permit, the construction declaration is made on the basis of being subject to an arbitrary settlement law.
For the dates of issuance of a permit / construction based on a declaration of affiliation, the scoring is as follows:
(x5≤09.08.1955) = 100 points,
(10.08.1955≤ x5≤09.06.1975) = 80 points,
(10.06.1975≤ x5≤31.12.1982) = 60 points,
(01.01.1983≤ x5≤31.12.1992) = 45 points,
(01.01.1993≤ x5≤31.12.2003) = 30 points,
(01.01.2004≤ x5≤31.12.2011) = 15 points
(x5> 1.1.2012) = 0 points
The real problem is this! And I would like to introduce a functions tofind thw solution! Could you helpme???
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)
- if it isn't difficult I want two screenshot in which I wouldlike to see and thw number of bar/cell tobe clear, cause on these pictures a see only the formulas
Here is the sample workbook.
HansVogelaar last question! COULD YOU HELP ME???