Multi calculate in one time


(Meysam) #1

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;


(daniel.beckett) #2

It looks like your output is split into separate decimal values that are separated by commas. You could use the Text service and use the ‘Split Text’ option to split the output on each comma. You’d then have an output for each number that you could include.

This would be on a one-by-one basis though unfortunately so you’d need to add each one into the card or card set.