2 replies
by thechas
Create a cell entry where you will store the exchange rate.
Create a formula that multiplies the price in Euros by the exchange rate to display the price in AU dollars.
Say the conversion rate is 1.15 AU dollars to 1 Euro. Your conversion rate cell is A1.
Prices in Euros are in cells C1 through C5.
Formula in E1 would be +C1*$A$1
E2 +C2*$A$1
(the dollar signs in the formula lock the reference cell to A1 for the calculation.
If you move or copy the formula to other cells, A1 will still be the reference.)
Then, adjust the format for Cells E1 through E5 to Australian dollars.
Chas
by cptomlly
You will simply need to create a formula that multiplies the price in Euros by the exchange rate. Example: If you have the item number in column A and corresponding prices in column B, then you would want to create a formula like =B1*exchg_rate in C1. You may want to enter the exchange rate at the bottom of the spreadsheet somewhere (outside the range of the pricelist), so then you can refer to this value in your formula. This will allow you to change the exchange rate in one location, rather than in EVERY formula. For example, if your spreadsheet goes all the way down to row 60, then in cell B63 enter the exchange rate (1.63235 per www.xe.com). Then your formula would look like this: =B1*$B$63 You have to add the dollar signs on to the cell with the exchange rate.
Once you get the formula entered in the first cell (c1 in my example), you need to fill it down the length of the price list. Click on the bottom right corner of the cell (you will notice this corner has a little square on it) and drag it down the length of the column to the last price. You should see a gray outline around the cells. When you release, it will "fill" the cells with the formula, but change it for each row as necessary (i.e. in C2, the formula will be =B2*$B$63).
Then you will probably want to format the cells to look like currency. This time click in the middle of the top cell (c1 in my example) and drag down. This will select the cells (the entire cell range should be highlighted). Then click Format>Cells..., Click the General tab, and choose Currency in the Categories list. You can then change the symbol to $ and make sure your decimal places are set at two. Click OK.
If you want, you can then hide the column with the price in Euros by right clicking the column with the Euro prices (column B in my example) and select "Hide". To unhide later, select column on each side of the hidden column (column A & C), right-click and "unhide".
Hope this helps.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending