+3I have an Excel formula I'd like to replicate in Airtable.
This formula converts different currencies into GBP.
Excel:
=IF(M2+(N2/1.25)+(O2/1.2)+(P2/8.75)=0,"",M2+(N2/1.25)+(O2/1.2)+(P2/8.75))
Key:
| £ GBP | $ USD | € EUR | ¥ CNY |
| M2 | N2 | O2 | P2 |
How would I go about it?
Best answer by Nyaruko
Hi send_help_pls,
Since you're coming from Excel, I'll include the excel terminology parenthetically.
First, make a new table (sheet), and name fields (columns) 2-5:
GBP, USD, EUR, CNY
Set them up as currency fields (columns) with their respective symbols.
Next, add a Converted to GBP field (column) as a formula field.
Use the following formula:
IF(
{GBP} + ({USD} / 1.25) + ({EUR} / 1.2) + ({CNY} / 8.75) = 0,
"",
{GBP} + ({USD} / 1.25) + ({EUR} / 1.2) + ({CNY} / 8.75)
)This should convert any of the currency fields into GBP.
+5Hi send_help_pls,
Since you're coming from Excel, I'll include the excel terminology parenthetically.
First, make a new table (sheet), and name fields (columns) 2-5:
GBP, USD, EUR, CNY
Set them up as currency fields (columns) with their respective symbols.
Next, add a Converted to GBP field (column) as a formula field.
Use the following formula:
IF(
{GBP} + ({USD} / 1.25) + ({EUR} / 1.2) + ({CNY} / 8.75) = 0,
"",
{GBP} + ({USD} / 1.25) + ({EUR} / 1.2) + ({CNY} / 8.75)
)This should convert any of the currency fields into GBP.
+3Hi send_help_pls,
Since you're coming from Excel, I'll include the excel terminology parenthetically.
First, make a new table (sheet), and name fields (columns) 2-5:
GBP, USD, EUR, CNY
Set them up as currency fields (columns) with their respective symbols.
Next, add a Converted to GBP field (column) as a formula field.
Use the following formula:
IF(
{GBP} + ({USD} / 1.25) + ({EUR} / 1.2) + ({CNY} / 8.75) = 0,
"",
{GBP} + ({USD} / 1.25) + ({EUR} / 1.2) + ({CNY} / 8.75)
)This should convert any of the currency fields into GBP.
You're a legend, thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
