Skip to main content

Need Help With A Currency Formula

P

Hi There

I have a column (Net Sales USD/CDN) that is populated with various mounts. In another column (Currency) I have indicated which of those amounts are USD currency and CDN currency.

In a new column (Total Net CDN Sales) I would like to come up with a formula where it converts the USD currency amounts to CDN currency using a currency rate of 1.3 and leaves the CDN currency amounts as they are.

Your help will be greatly appreciated.

Thanks so much.

2 replies

Justin_Barrett
Forum|alt.badge.img+20

Does this look right?

Here’s the formula in the final field:

IF(Currency="CDN", {Net Sales USD/CDN}, {Net Sales USD/CDN} * 1.3)
P
Justin_Barrett wrote:

Does this look right?

Here’s the formula in the final field:

IF(Currency="CDN", {Net Sales USD/CDN}, {Net Sales USD/CDN} * 1.3)

Hi Justin

Thanks so much for the help, it worked.

Much appreciated.

Reply


Most helpful members this week

Terms & Conditions