Need Help With A Currency Formula

[Pedro_de_Nobrig]

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.

[Justin_Barrett]

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)

[Pedro_de_Nobrig]

Hi Justin

Thanks so much for the help, it worked.

Much appreciated.