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?
+20Could 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?
+14@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.
+2JBJ wrote:
@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.
+14Arna_Miller wrote:
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.