Help

Re: How to convert formula from Excel to Airtable

Solved
Jump to Solution
318 1
cancel
Showing results for 
Search instead for 
Did you mean: 
send_help_pls
4 - Data Explorer
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
M2N2O2P2

How would I go about it?

 

1 Solution

Accepted Solutions
Nyaruko
5 - Automation Enthusiast
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.
currency-conversion-to-gbp.png

See Solution in Thread

2 Replies 2
Nyaruko
5 - Automation Enthusiast
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.
currency-conversion-to-gbp.png

You're a legend, thank you!