adding another formula to an IF function

[jstnvndn]

Hello,
I have a costing sheet that allows me to calculate my product costs in US dollars. I also need to figure out my Canadian costs of the same product.
I will be able to enter in my unit cost in US dollars, and then I have a conversion chart that keeps my current exchange rate between the US and Canadian dollar.

Can the formulas in the spreadsheet be configured to work so that when the access the conversion chart, it will put the costing in the correct currency?

I think the spreadsheet was built when the US dollar was stronger than the Canadian dollar, but now the Canadian dollar is stronger and the spreadsheet cannot account for that.

I want the US costings to be costed out in US dollars, and then I want to use the same costing sheet to cost out the product in Canadian dollars when I input a conversion rate in cell F9.

Thanks,