By no means am I an Excel guru but I am curious to know if this is possible within excel.
Reason we are a Canadian Dealer and a lot of our suppliers are south of the 49th and we deal with exchange rates on a daily basis.
How do you compute this equation below in excel?
TIA
Adjustment = FCC x Qty x ( i1 - i0 ) / i0
where formula variables correspond to:
FCC Foreign Currency Component (per unit)
i0
Initial exchange rate (CAN$ per unit of foreign currency [e.g. US$1])
i1
exchange rate for adjustments (CAN$ per unit of foreign currency [e.g. US$1])
Qty quantity of units
Bookmarks