How to extract cube root in google spreadsheets?

Question

Google Sheets

You need to calculate the cube root of a negative number in Googletabs. There is no cube root function. The POWER() exponentiation function allows you to raise only positive numbers to the 1/3 power, otherwise it swears at an imaginary number.

Answer 1

Alternatively, only a combination of formulas
=SIGN(-9)*ABS(-9)^(1/3)