View previous topic :: View next topic |
Author |
Message |
marcelo Contributor
Joined: 10 May 2008 Posts: 149
|
Posted: Sat May 07, 2022 2:04 am Post subject: Mathematic functions |
|
|
Hi. Im trying to replace some excell formullas with a VDS Script.
ie: I found num^2 and i can replace it with @prod(num,num)
But i found num^10 and i can't find a function to do that...
Is there any whay to do it without having to repeat the multiplication 10 times?
Thanks a lot in advance |
|
Back to top |
|
|
uvedese Contributor
Joined: 21 Jan 2006 Posts: 169 Location: Spain
|
Posted: Sat May 07, 2022 11:47 am Post subject: |
|
|
Hi Marcelo
How long without knowing about you!!!
In VDS 6 I wonder if it will be possible to use Google calculation. It could capture the results of the web code, perhaps
Mathematically it could be done like this:
Code: | option decimalsep,.
# 2^3 Result must be 8
%%Base = 2
%%Exponent = 3
info @fexp(@fmul(%%Exponent,@fln(%%Base))) |
|
|
Back to top |
|
|
marcelo Contributor
Joined: 10 May 2008 Posts: 149
|
Posted: Sat May 07, 2022 1:40 pm Post subject: |
|
|
YEAH!!! Nice to see you again!!!!
Thanks por the code it works perfect for my need.
I tell you i mailed to ED1 and i will buy VDS 6 soon. (actually 6.1) |
|
Back to top |
|
|
cnodnarb Professional Member
Joined: 11 Sep 2002 Posts: 763 Location: Eastman, GA
|
Posted: Tue May 10, 2022 1:28 am Post subject: |
|
|
You won't regret it (6.1) |
|
Back to top |
|
|
GregLand Valued Contributor
Joined: 15 Jun 2004 Posts: 212 Location: FRANCE
|
Posted: Tue May 10, 2022 2:16 pm Post subject: |
|
|
cnodnarb wrote: | You won't regret it (6.1) |
I think so |
|
Back to top |
|
|
|