Arcade root cube different results than Excel

456
2
Jump to solution
03-15-2024 07:19 PM
KeithWestberg
New Contributor II

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. 

1 Solution

Accepted Solutions
KenBuja
MVP Esteemed Contributor

You have to use the Pow function.

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

 

pow.png

View solution in original post

Tags (1)
2 Replies
KenBuja
MVP Esteemed Contributor

You have to use the Pow function.

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

 

pow.png

Tags (1)
KeithWestberg
New Contributor II

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

0 Kudos