Silly Question

[Bob Todd]

Hello,

How do I get what is linked (pictured) into an excel formula

Thanks in advance
Bob


https://drive.google.com/file/d/1c_Xg4vykTaC2fcuAfO0BAhSy-sHBt7JD/view?usp=sharing

 

[MUKESHY12390]

sorry I can't see you attached.

basically what you want ,, how many range involves in formula?

 

[Bob Todd]

Its a formula like whats below, but I'm having difficulty making it work.

=128,400/(1+.14)^1+182,160/(1+.14)^2+166,120/(1+.14)^3+167,760/(1+.14)^4+449,560/(1+.14)^5-662,000



Thanks

 

[Dave Patton]

The formula seems to work.
Try
=128400/(1+0.14)^1+182160/(1+0.14)^2+166120/(1+0.14)^3+167760/(1+0.14)^4+449560/(1+0.14)^5-662000

 

[Bob Todd]

It worked, not sure what I was doing wrong

thank you!

 

[thisoldman]

Hi Bob,
You were including a comma in your numbers. Excel interprets numbers with a comma inside any formula as text.