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

[Steven_Keith]

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?

[Justin_Barrett]

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?

[Nick_Longley]

Compound interest formula please

[HARIKRISHNAN-AK]

I would like to know the solution for this problem

[JBJ]

@Steven, @Nick_Longley, @HARIKRISHNAN-AK If you're still struggling with this, could you please elaborate on what's causing you trouble? I'm willing to help out.

[Arna_Miller]

I have the same issue.  Here is the google sheets formula:  =(0.028*((D6)^0.8))

What would the airtable formula be?  D6 is the cell number.

[JBJ]

 Hi @Arna_Miller,

Here are screenshots showing you how to use the function POWER().

If you check the result on a calculator, you'll see that it all checks out.

Hope it helps.

JBJ
🌊 Keep the Flow