May 10, 2020 02:21 PM
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
May 12, 2020 10:36 AM
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)
.
May 14, 2020 03:37 AM
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,
Mar 17, 2022 03:44 AM
Hey Maichel,
was wondering, did you manage to get this working?
We’re also using Airtable for experimentation tracking, maybe we could share tips?