Hi; I'm trying to enter over 125 cell references in an NPV formula, example =npv(rate, v1,v2,v3 ... v125). When I do the range x:y it does not work. Is there an easier way than enter one by one?
Hi; I'm trying to enter over 125 cell references in an NPV formula, example =npv(rate, v1,v2,v3 ... v125). When I do the range x:y it does not work. Is there an easier way than enter one by one?
Using a range works fine, listing 125 separate arguments will not.
Post an example?
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks