-
brookstonefinancialAsked on March 20, 2014 at 12:09 PM
Hoping to use the Caret ^ function within the new form calculations. Anyway to do this? Any information would be much appreciated. Thanks.
-
KadeJMReplied on March 20, 2014 at 2:27 PM
I apologize but unfortunately I'm not all that familiar with Caret Functions. Are you referring to this sort of thing mentioned here http://en.wikipedia.org/wiki/Caret which is referenceing the " " hat per say?
I found the below explaination about how to use it for mathematics:
Can you confirm if this is what you seek?
Surrogate symbol for superscript and exponentiation[edit]In mathematics, the caret can signify exponentiation (3^5 for ), where the usual superscript is not readily usable (as on some graphing calculators). The caret is also now used to indicate a superscript in TEX typesetting. As Isaac Asimov described it in his 1974 "Skewered" essay (on Skewes' number), "I make the exponent a figure of normal size and it is as though it is being held up by a lever, and its added weight when its size grows bends the lever down."[13] The use of the caret for exponentiation can be traced back to ALGOL 60,[citation needed] which expressed the exponentiation operator as an upward-pointing arrow, intended to evoke the superscript notation common in mathematics. The upward-pointing arrow is now used as a form ofiterated exponentiation in Knuth's up-arrow notation.
I don't think that we have that as a function for calculations since I do not see it listed as an option and based on what I read about it I am thinking this is something that is much more advanced versus what we currently offer with the calculation widget. However, I will gladly go ahead and open up a feature improvement request for this to pass along to our developers so they can look into considering it.
-
brookstonefinancialReplied on March 20, 2014 at 2:40 PMYes this is the correct function that you are referring too. Is there another way to implement this math formula…like pow() maybe??
Justin Allen
812.225.0516
IT Administrator
Creative Services Director
www.brookstonefinancial.com
... -
Welvin Support Team LeadReplied on March 20, 2014 at 4:28 PM
Hi Justin,
Your suggestion is already forwarded to our developers. You should be notified via this thread if there are progress made into this.
Thanks
-
brookstonefinancialReplied on March 21, 2014 at 11:00 AMThanks for the fast response. I’ll work on getting this implemented! Below is a formula from an excel spreadsheet that I’m trying to integrate into jotforms. You can see the ^ icon, hopefully I’ll figure this out through jotform. If you know how this should look within jotform, let me know, otherwise thanks again for the response. Look forward to using this new feature within jotform!
=B2*(1+B3/B4)^(B4*B5)-B2
Justin Allen
812.225.0516
IT Administrator
Creative Services Director
www.brookstonefinancial.com
... -
brookstonefinancialReplied on March 21, 2014 at 11:30 AMNicholas,
I’ll try this, thanks so much man!
Justin Allen
812.225.0516
IT Administrator
Creative Services Director
www.brookstonefinancial.com
... -
brookstonefinancialReplied on March 24, 2014 at 12:20 PMNicholas,
Thanks so much for the help and information. Forgive me if this I’m not understanding the following content below, but can you help me format the proper formula for the following, or will the below formula that you provided work for what I’m trying to accomplish? Thanks
Here are my fields..
Principle
Annual Interest Rate
Compounding Periods Per Year
Years
Amount Earned
Justin Allen
812.225.0516
IT Administrator
Creative Services Director
www.brookstonefinancial.com
... -
brookstonefinancialReplied on March 24, 2014 at 1:50 PMThat’s it! Thanks so much man!
Justin Allen
812.225.0516
IT Administrator
Creative Services Director
www.brookstonefinancial.com
... -
CarinaReplied on March 24, 2014 at 3:55 PM
On behalf of my colleague you are most welcome.
Let us know if we can be of more assistance.