How to convert formula from Excel to Airtable

[send_help_pls]

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?

[Nyaruko · Accepted solution]

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.

[send_help_pls]

You're a legend, thank you!