Skip to main content

Hi all, i am trying to reproduce an exel formula that calculates the Minimum Sample Size based on some values in Airtable.


the formula in excel is like this:

=IF(AB2;ROUNDUP((1,644853625*(2I2(1-I2))^0,5+0,8416212327*(I2*(1-I2)+(I2+(I2AC2))(1-I2-(I2AC2)))^0,5)^2/((I2AC2)^2);0)*K2;0,1)


Reference:

AB2 = value from call (TRUE/FALSE)

I2 = 10% (value from cell)

AC2 = 20% (value from cell)

K2 = 2 (value from sell)

I am stuck with the use of “^” (power)


any suggestions?


Thanks in advance.


Regards Maichel

Excel > Airtable


The biggest transition will be converting your formula so that instead of cell references, you refer to an entire column or field. Example:


  A        B        C

1 Fruit    Color    Color + Fruit    Excel Formula    Airtable Formula

2 Apple    Red      AppleRed         A2 & B2          {Fruit} & {Color}

Power


Checkout the formula field reference. Instead of Base ^ Power, you’ll use POWER(base, power).

Excel > Airtable


The biggest transition will be converting your formula so that instead of cell references, you refer to an entire column or field. Example:


  A        B        C

1 Fruit    Color    Color + Fruit    Excel Formula    Airtable Formula

2 Apple    Red      AppleRed         A2 & B2          {Fruit} & {Color}

Power


Checkout the formula field reference. Instead of Base ^ Power, you’ll use POWER(base, power).


Thanks Zollie, i will need to play around with the (POWER(base,power) furmula. i will get back when i get it working or get stuck again,

Thanks Zollie, i will need to play around with the (POWER(base,power) furmula. i will get back when i get it working or get stuck again,


Hey Maichel,


was wondering, did you manage to get this working?

We’re also using Airtable for experimentation tracking, maybe we could share tips?

Reply


Terms & Conditions