NPV with greater than 29 arguments

[Rosemary]

Is there any way to calculate NPV with greater than 29 arguments?

 

[Harlan Grove]

Is there any way to calculate NPV with greater than 29 arguments?

=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.

 

[Rosemary]

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))

 

[Rosemary]

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.

 

[Harlan Grove]

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))

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

=NPV(C2,A5:A33)