Hello,
<tbody>
</tbody>
I've read through many help pages trying to solve my problem, but to be honest I don't think I am correctly wording what I am trying to do.
I've attached a picture to help illustrate my query. The purpose of this part of the spreadsheet is to select an appropriate contract size adjustment for a property contractor's valuation.
The top cell contains a cost of construction (coc), which is variable depending on other figures above this.
Taking the first row as an example, if the coc is between £0 and £500,000 then the coc should be adjusted by 0.100. I would like the green cell to read +10% (or even 10%).
Taking a middle row as an example, if the coc is £4,200,000 then the coc should be adjusted by -0.015. I would like the green cell to read -1.5%.
Taking the bottom row as an example, if the coc is over £20,000,000 then the coc should be adjusted by -0.100. I would like the green cell to read -10%.
<tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<tbody>
</tbody>
I've read through many help pages trying to solve my problem, but to be honest I don't think I am correctly wording what I am trying to do.
I've attached a picture to help illustrate my query. The purpose of this part of the spreadsheet is to select an appropriate contract size adjustment for a property contractor's valuation.
The top cell contains a cost of construction (coc), which is variable depending on other figures above this.
Taking the first row as an example, if the coc is between £0 and £500,000 then the coc should be adjusted by 0.100. I would like the green cell to read +10% (or even 10%).
Taking a middle row as an example, if the coc is £4,200,000 then the coc should be adjusted by -0.015. I would like the green cell to read -1.5%.
Taking the bottom row as an example, if the coc is over £20,000,000 then the coc should be adjusted by -0.100. I would like the green cell to read -10%.