Hi All,
I'm trying to create a sensitivity analysis for my real estate proforma. I want to see my margin (%) and profit ($) as the price increases or decreases. In my previous version, I was only looking at one input (price), however, now Ihave two inputs to look at different types of projects (midrise / lowrise) on the same property.
I am struggling to create a data table that works, because my "Input Column" is actually a sum of two cells (see below), and the data table will not work if the cell i use as input is C14 because it is a formula =Sum(C12:C13).
Any suggestions, is this possible?
Thanks in advance!
I'm trying to create a sensitivity analysis for my real estate proforma. I want to see my margin (%) and profit ($) as the price increases or decreases. In my previous version, I was only looking at one input (price), however, now Ihave two inputs to look at different types of projects (midrise / lowrise) on the same property.
I am struggling to create a data table that works, because my "Input Column" is actually a sum of two cells (see below), and the data table will not work if the cell i use as input is C14 because it is a formula =Sum(C12:C13).
Any suggestions, is this possible?
Thanks in advance!
