Forum Discussion

emmapapa2's avatar
emmapapa2
Copper Contributor
Dec 09, 2021

SOS QUESTION EXCEL

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 help me???

2 Replies

    • emmapapa2's avatar
      emmapapa2
      Copper Contributor
      YOU HAVE RIGHT! BUT IS THE FIRST TIME TO USE THIS PLATFORM! SORRY

Resources