Power, exponent or Airtable's version of Excel's ^ symbol

#1

I am trying to emulate MS Excel’s “^” function in Airtable. I have tried the POWER function and it doesn’t seem to work. Optimally, I am calculating Customer Lifetime Value. Any clues about how to effectively do this?

#2

Could you give an example of what you’re trying to achieve, and the results you’re getting with POWER that aren’t what you expect?