I have a formula fro NPV
=npv(a1,i2:i10)
The range i2:i10 will change, I have a second cell O10 where I have set the address of the start of the range using the address fomula address(2,9). When I try to use the results of cell O10 as the start of the range I am getting an error, I have also tried NPV(a1,address(2,9):i10) and it returns a value error. Can anyone help.
Thanks
=npv(a1,i2:i10)
The range i2:i10 will change, I have a second cell O10 where I have set the address of the start of the range using the address fomula address(2,9). When I try to use the results of cell O10 as the start of the range I am getting an error, I have also tried NPV(a1,address(2,9):i10) and it returns a value error. Can anyone help.
Thanks