topic Re: Arcade root cube different results than Excel in Developers Questions

Arcade root cube different results than Excel

KeithWestberg — Sat, 16 Mar 2024 02:33:38 GMT

I have an equation in excel which is =130*(27^(1/3)) that returns 390. When i use this same formula in Playground and arcade via Pro, i get 3510. I've tried every order of operation, but still cannot emulate the excel output.

The playground version is the following

return 130*(27^(1/3));

Any suggestions on why the difference would be greatly appreciated. Thank you in advance.

Re: Arcade root cube different results than Excel

KenBuja — Sat, 16 Mar 2024 04:32:26 GMT

You have to use the Pow function.

return 130 * Pow(27, (1/3))

Re: Arcade root cube different results than Excel

KeithWestberg — Sat, 16 Mar 2024 14:10:00 GMT

I had discovered that function but i was not using it correctly. Thank you for the lightning fast response. You rock!