adding another formula to an IF function

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,

Hello jstnvndn,

After looking at the workbooks, I have a couple of questions:

1. Do the conversion rates need to be in another workbook as they are now?
2. You have the US dollars in H8 and Canadian dollars in H9. There are several formulas in column "H" like this "=(H8+H9)*D12/100". Once the US amount is converted, won't this more than double the cost?

Hi, Not sure why H8 is added to H9.

As for the conversion rates, I don't know if they need to be separate. We have that file and it has multiple conversion rate information, but the costing always starts with a US dollar supplier cost. The product we buy is always in US dollars, and then when we do a US costing to see what our final cost of the goods are, we leave the conversion rate cell blank, because it is 1 to 1.

When we put together our final costs for Canada, we input the supplier cost in US dollars and then put in a conversion rate and the spreadsheet needs to output a final cost in Canadian dollars.

So depending on what Country the costing is for, the field for H8 is only used for US costings and the field for H9 is only used when it is a Canadian costing.

Hope that helps clear things up on how we want the spreadsheet to work.

Hello jstnvndn,

Thanks for the update. Looking at the sheet as customer, the dollars amounts are bit confusing having the Canadian dollar symbol always present. If cell "G9" had a drop down to show either US or Canadian dollars it would be less confusing. The drop down could also add in the correct conversion rate. Just a thought.

Hi, these are only internal costing sheets for us so that we can see what the total cost of goods are.

But, I don't mind the drop down thing either, that you suggest. Can you work in the formula for me to try out and see how it works?

Hello jstnvndn,

Sure, I can do that.

jstnvndn,

See if this can help:

Currency Conversion Macro
This article presents a guide to using the "currency conversion" demo web service from within Microsoft Excel.
http://www.webcontinuum.net/ws_4.aspx