Skip to main content

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?

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?

Compound interest formula please

I would like to know the solution for this problem

@Steven11, @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.

@Steven11, @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.


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.

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.


 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

Terms & ConditionsAccessibility statement