How to convert formula from Excel to Airtable

Topic Labels: Formulas
Solved
Jump to Solution
322 2
cancel
Showing results for
Search instead for
Did you mean:
4 - Data Explorer

I 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?

1 Solution

Accepted Solutions
5 - Automation Enthusiast

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.

2 Replies 2
5 - Automation Enthusiast

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.

4 - Data Explorer

You're a legend, thank you!