Hi All,
I am having trouble trying to work this one out. I can't figure out the formula that goes in the green cells highlighted below. In the green cells I want to increase the cost base of each property by the % from the data below, based on whether the property is allocated as a house/unit, and what postcode it belongs to. For example. Property 1's cost-base of $200k would increase by 3.5% as it's a house and has the postcode 3500. Therefore the amount in the green adjustment cell will be $7,000.
Really appreciate any feedback.
Cheers
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"><col width="100"><col width="131"></colgroup><tbody>[TR]
[TD]Property Name[/TD]
[TD][/TD]
[TD]Postcode[/TD]
[TD]Cost Base[/TD]
[TD]Adjustment[/TD]
[TD]New Adjusted Value[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Property 1[/TD]
[TD="align: center"]House[/TD]
[TD="align: center"]3500[/TD]
[TD="align: right"]200000[/TD]
[TD="bgcolor: #93c47d"][/TD]
[TD="bgcolor: #f6b26b"][/TD]
[/TR]
[TR]
[TD]Property 2[/TD]
[TD="align: center"]Unit[/TD]
[TD="align: center"]3400[/TD]
[TD="align: right"]300000[/TD]
[TD="bgcolor: #93c47d"][/TD]
[TD="bgcolor: #f6b26b"][/TD]
[/TR]
[TR]
[TD]Proprety 3[/TD]
[TD="align: center"]House[/TD]
[TD="align: center"]3300[/TD]
[TD="align: right"]400000[/TD]
[TD="bgcolor: #93c47d"][/TD]
[TD="bgcolor: #f6b26b"][/TD]
[/TR]
</tbody>[/TABLE]
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="100"><col width="100"></colgroup><tbody>[TR]
[TD]Data - Increase in Market Value
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]House[/TD]
[TD="align: right"]3500[/TD]
[TD="align: right"]3.50%[/TD]
[/TR]
[TR]
[TD]Unit[/TD]
[TD="align: right"]3500[/TD]
[TD="align: right"]2.00%[/TD]
[/TR]
[TR]
[TD]House [/TD]
[TD="align: right"]3400[/TD]
[TD="align: right"]3.00%[/TD]
[/TR]
[TR]
[TD]Unit[/TD]
[TD="align: right"]3400[/TD]
[TD="align: right"]1.25%[/TD]
[/TR]
[TR]
[TD]House [/TD]
[TD="align: right"]3300[/TD]
[TD="align: right"]3.25%[/TD]
[/TR]
[TR]
[TD]Unit[/TD]
[TD="align: right"]3300[/TD]
[TD="align: right"]1.75%[/TD]
[/TR]
</tbody>[/TABLE]
I am having trouble trying to work this one out. I can't figure out the formula that goes in the green cells highlighted below. In the green cells I want to increase the cost base of each property by the % from the data below, based on whether the property is allocated as a house/unit, and what postcode it belongs to. For example. Property 1's cost-base of $200k would increase by 3.5% as it's a house and has the postcode 3500. Therefore the amount in the green adjustment cell will be $7,000.
Really appreciate any feedback.
Cheers
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="100"><col width="100"><col width="100"><col width="100"><col width="131"></colgroup><tbody>[TR]
[TD]Property Name[/TD]
[TD][/TD]
[TD]Postcode[/TD]
[TD]Cost Base[/TD]
[TD]Adjustment[/TD]
[TD]New Adjusted Value[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Property 1[/TD]
[TD="align: center"]House[/TD]
[TD="align: center"]3500[/TD]
[TD="align: right"]200000[/TD]
[TD="bgcolor: #93c47d"][/TD]
[TD="bgcolor: #f6b26b"][/TD]
[/TR]
[TR]
[TD]Property 2[/TD]
[TD="align: center"]Unit[/TD]
[TD="align: center"]3400[/TD]
[TD="align: right"]300000[/TD]
[TD="bgcolor: #93c47d"][/TD]
[TD="bgcolor: #f6b26b"][/TD]
[/TR]
[TR]
[TD]Proprety 3[/TD]
[TD="align: center"]House[/TD]
[TD="align: center"]3300[/TD]
[TD="align: right"]400000[/TD]
[TD="bgcolor: #93c47d"][/TD]
[TD="bgcolor: #f6b26b"][/TD]
[/TR]
</tbody>[/TABLE]
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 100px"><col width="100"><col width="100"></colgroup><tbody>[TR]
[TD]Data - Increase in Market Value
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]House[/TD]
[TD="align: right"]3500[/TD]
[TD="align: right"]3.50%[/TD]
[/TR]
[TR]
[TD]Unit[/TD]
[TD="align: right"]3500[/TD]
[TD="align: right"]2.00%[/TD]
[/TR]
[TR]
[TD]House [/TD]
[TD="align: right"]3400[/TD]
[TD="align: right"]3.00%[/TD]
[/TR]
[TR]
[TD]Unit[/TD]
[TD="align: right"]3400[/TD]
[TD="align: right"]1.25%[/TD]
[/TR]
[TR]
[TD]House [/TD]
[TD="align: right"]3300[/TD]
[TD="align: right"]3.25%[/TD]
[/TR]
[TR]
[TD]Unit[/TD]
[TD="align: right"]3300[/TD]
[TD="align: right"]1.75%[/TD]
[/TR]
</tbody>[/TABLE]