I have a database on google sheet that it has 10 rows.
By calculate in number I catch one cell per rows and calculate something by it like below:
Expression
0.01*(1+(0.012))3591.5524500712545*120611 0.01(1+(0.013))3591.5524500712545120611 0.01(1+(0.01-5))3591.5524500712545120611 0.01(1+(0.01-6))3591.5524500712545120611 0.01(1+(0.01-4))3591.5524500712545120611 0.01(1+(0.0110))3591.5524500712545120611 0.01(1+(0.012))3591.5524500712545120611 0.01(1+(0.015))3591.5524500712545120611 0.01(1+(0.016))3591.5524500712545120611 0.01(1+(0.013))3591.5524500712545120611 0.01(1+(0.013))3591.5524500712545120611 0.01(1+(0.013))3591.5524500712545120611 0.01(1+(0.014))3591.5524500712545120611 0.01(1+(0.014))3591.5524500712545120611 0.01(1+(0.015))3591.5524500712545120611 0.01(1+(0.01-9))3591.5524500712545120611 0.01(1+(0.01-6))3591.5524500712545120611 0.01(1+(0.01-3))3591.5524500712545120611 0.01(1+(0.01-4))3591.5524500712545120611 0.01(1+(0.012))3591.5524500712545120611 0.01(1+(0.013))3591.5524500712545120611 0.01(1+(0.013))3591.5524500712545120611 0.01(1+(0.015))3591.5524500712545120611 0.01(1+(0.012))3591.5524500712545120611 0.01(1+(0.015))3591.5524500712545120611 0.01(1+(0.01-7))3591.5524500712545120611 0.01(1+(0.016))3591.5524500712545120611 0.01(1+(0.011.4))3591.5524500712545120611 0.01(1+(0.013))3591.5524500712545120611 0.01(1+(0.017))3591.5524500712545120611
Result
[4418443.47206655,4461761.545322103,4115216.959277669,4071898.8860221147,4158535.032533223,4764988.058110986,4418443.47206655,4548397.691833213,4591715.765088767,4461761.545322103,4461761.545322103,4461761.545322103,4505079.618577659,4505079.618577659,4548397.691833213,3941944.6662554513,4071898.8860221147,4201853.1057887785,4158535.032533223,4418443.47206655,4461761.545322103,4461761.545322103,4548397.691833213,4418443.47206655,4548397.691833213,4028580.81276656,4591715.765088767,4392452.628113218,4461761.545322103,4635033.8383443225]
I want to use format number these results but it show below error:
Number is not a number
And at least I want to use these number in âsend a set cardsâ by * (repeat magically).
Unfortunately, * just work in google sheet output array.
I want to know how can I use caculate output array.
Best regards;