Skip to main content

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.

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)

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