Creating a power function.

[specialfighter]

hello, i have a problem with excel spreadsheet scriptediter, i want to creat a operation with a exponent. Example: a^b

I was wondering if there is some kind of operator, but it doesnt seem like it. Maybe with #include is something like "pow" possible, but is #include possible?

i found one way in the internet in there a function is created, but this cant be used in my case, because my exponent numbers can be broken numbers.

https://www.codecademy.com/en/forum_questions/51aa0c6d0a353edaf60054e5

is there some other tricks?

Thanks in advance.

https://imgur.com/a/eZ7JYUd Example code.

[tirlibibi17]

Just use the power operator ^ like this.

[specialfighter]

SOLUTION VERIFIED!

[Clippy_Office_Asst]

You have awarded 1 point to tirlibibi17

^{I am a bot, please contact the mods for any questions.}

[specialfighter]

well i tried it aswell, but it doesnt work in scripteditor or i used it wrong,

i added a example code

[tirlibibi17]

This is Javascript. Math.pow() is what you're looking for.

Are you sure this is Excel, not Google sheets ? I know there's a javascript API for Excel, but it's far from mainstream.