Forum Discussion
Name range in formula
English isn't my first language so sorry in advanced.
Hi, I'm using Excel 2016. My teacher use the name range in NPV formula but somehow I can't use it at all.
In details: my teacher name 2 range, each has 15 values, "benefit" and "cost" respectively. Then she use this exact formula "npv(rate,benefit-cost)" and the result was right. But when I use it the formula only calculate the first value in the string of value.
Therefore I can't use formula like "npv(rate, benefit*(1-%change)-cost)" like she did to evaluate changes.
I have attach photos example, unfortunately I dont have photos of my teacher's work
Can anyone explain to me why and how I can fix it, much appreciate.
Hi, I'm using Excel 2016. My teacher use the name range in NPV formula but somehow I can't use it at all.
In details: my teacher name 2 range, each has 15 values, "benefit" and "cost" respectively. Then she use this exact formula "npv(rate,benefit-cost)" and the result was right. But when I use it the formula only calculate the first value in the string of value.
Therefore I can't use formula like "npv(rate, benefit*(1-%change)-cost)" like she did to evaluate changes.
I have attach photos example, unfortunately I dont have photos of my teacher's work
Can anyone explain to me why and how I can fix it, much appreciate.
5 Replies
I think what you were missing is the absolute reference for the Rate portion of the formula. I didn't check the results but see if this works.
=NPV($B$2,@benefit-@cost)
The "$" dollar signs make each formula, all the way down the column, continue to refer to B2 even though the other references are changing.
