Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to convert formula from Excel to Airtable

Topic Labels: Formulas
Solved
Jump to Solution
936 2
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!