NPV with greater than 29 arguments

  • Thread starter Thread starter Guest
  • Start date Start date
Is there any way to calculate NPV with greater than 29 arguments?
Click to expand...

=NPV(DiscountRate,(A1,B2,C3,D4,E5,F6,G7,H8,I9,J10,K11,L12,M13,N14,O15,P16,
Q17,R18,S19,T20,U21,V22,W23,X24,Y25,Z26,AA1,AB2,AC3,AD4,AE5,AF6,AG7,AH8,
AI9,AJ10,AK11,AL12,AM13,AN14,AO15,AP16,AQ17,AR18,AS19,AT20,AU21,AV22,AW23,
AX24,AY25,AZ26))

works just fine because there are only two arguments in this NPV call. The
parentheses around the list of range addresses (single cell ranges in the
formula above) makes it a *single* reference to a multiple area range. There are
similar tricks for other situations, but why don't you show what your formula is
rather than making us guess.
 
Thanks for your help. This the my current formula

=(NPV(C2,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,A21,A22,A23,A24,A25,A26,A27,A28,A29,A30,A31,A32,A33))
 
I tried it the way you suggested and it works fine. In my formla C3 is the discount rate so I seperated it out and was able to include all 43 values.

Thanks so much for your help.
 
Rosemary said:
Thanks for your help. This the my current formula:

=(NPV(C2,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,
A19,A20,A21,A22,A23,A24,A25,A26,A27,A28,A29,A30,A31,A32,A33))
Click to expand...

This looks like a syntax error. If C2 is your discount rate, try

=NPV(C2,A5:A33)
 
Back
Top