Skip to main content

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


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
Forum|alt.badge.img+20

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


Forum|alt.badge.img

I would like to know the solution for this problem


JBJ
Forum|alt.badge.img+14
  • Known Participant
  • November 11, 2024

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


Forum|alt.badge.img+2
  • New Participant
  • November 23, 2024
JBJ 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.


JBJ
Forum|alt.badge.img+14
  • Known Participant
  • November 24, 2024
Arna_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