Need Help With A Currency Formula

#1

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.

0 Likes

#2

Does this look right?

24%20PM%201

Here’s the formula in the final field:

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

#3

Hi Justin

Thanks so much for the help, it worked.

Much appreciated.

0 Likes