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.

Formula for displaying $ value and an existing cell value

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

Hi all.

Sure this is super simple and I’m no doubt being super simple myself in not getting the solution…

I have a sheet where I am keeping track on recurring charges. I’m dealing with 3 specific columns in this sheet

Col 1 [$ Charge]
Col 2 [currency selection…eg AUD, USD, GBP etc)
Col 3 [$AUD Charge]

Ultimately for each line item I add, I want all charges to be converted to AUD (this would be COL3) and from there I can run further calculation based on this number.

So I’m assuming the formulas for column 3 would be:

If “Currency” is “AUD” then display the value already entered in “$ Charge”.

And…

If “Currency” is “USD” then multiply by “<FX rate that I’ll input>” then display the calculation as a “$ value”

I’m just not sure how I would write those formulas in Airtable?

Possible?
Thanks so much
Ian

1 Solution

Accepted Solutions

Hi @Ian_M,

Ya I did a mistake in the formula, sorry. The Currency in the first argument should be referring to a field.

IF({Currency}="AUD",{$ Charge}, {$ Charge}*{FX Rate})

Now it should work.

See Solution in Thread

4 Replies 4

strong textHi @Ian_M,

Welcome to Airtable Community! :grinning_face_with_big_eyes:

You will need a 4th field which is the exchange rate. The formula would then be

IF("Currency"="AUD",{$ Charge}, {$ Charge}*{FX Rate})

Hope this helps

BR,
Mo

Ian_M
4 - Data Explorer
4 - Data Explorer

Hey Mo! Thanks for your quick reply.

I dropped this in with the new field. It seems to work for the second condition but not quite for the the first.

So with the adjusted fields:

Field 1 ($ Charge) = $1.50
Field 2 [Currency) = AUD
Field 3 [FX Rate] = blank
Field 4 [$AUD Charge] = should therefore be the value of Field 1 - $1.50. But with your formula it seems to be showing as 0

Any thoughts?

Cheers
Ian

Ian_M
4 - Data Explorer
4 - Data Explorer

Hey Mo - realised if I just drop 1 into the FX Rate field, then it’ll solve that problem.

Which actually means I might as well just simplify this and not use IF formula. If I’m going to have the FX Rate field, then I just do a straight multiple Field 1 x Field 3 to get my answer.

Cheers
Ian

Hi @Ian_M,

Ya I did a mistake in the formula, sorry. The Currency in the first argument should be referring to a field.

IF({Currency}="AUD",{$ Charge}, {$ Charge}*{FX Rate})

Now it should work.