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?
Power, exponent or Airtable's version of Excel's ^ symbol
+21Could 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?
+17@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.
+2@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.
+17I 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
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.