Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert currency within column
I am receiving invoices in HKD I do not need to keep track of the HKD total,
only the USD total. The invoices are for different amounts. My goal is to enter the invoice total and have a formula in place that will automatically convert the HKD amount to USD using an exchange rate of 7.8 by dragging down the formula. I am trying to avoid having to type =HKD/7.8 Column B is for invoice total in USD (In my efforts to find a solution I have designated cell B21 for the exchange rate which is 7.8) Does anyone know if there is a simpler solution then typing =HKD/7.8? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert currency within column
If your HKD amounts were in column C and you wanted to convert to USD in
column D with the exchange rate in B21 and the data beginning in row 2, in D2 the formula =C2/$B$21 would be draggable. If you change the exchange rate though, that would change it for the past invoices as well. Is this what you are looking for? "Stephanie" wrote: I am receiving invoices in HKD I do not need to keep track of the HKD total, only the USD total. The invoices are for different amounts. My goal is to enter the invoice total and have a formula in place that will automatically convert the HKD amount to USD using an exchange rate of 7.8 by dragging down the formula. I am trying to avoid having to type =HKD/7.8 Column B is for invoice total in USD (In my efforts to find a solution I have designated cell B21 for the exchange rate which is 7.8) Does anyone know if there is a simpler solution then typing =HKD/7.8? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert currency to text | Excel Discussion (Misc queries) | |||
Convert currency of the whole worksheet | Excel Discussion (Misc queries) | |||
Convert currency to $X.XMM | Excel Discussion (Misc queries) | |||
How to convert currency into words? | Excel Discussion (Misc queries) | |||
add time and convert it to currency | Excel Worksheet Functions |