Hello Experts,
I have this excel sheet from our accouting department for liquidating our travel expenses. The final computation of expeses should be in US$.
My expenses are around 3 different foreign currency, chines rmb, phil peso, hkg dollar.
I would like to have in the cell that if i input 800 (chinese rmb), the cell will automatically change it into us$. This is same as with the other currency like philppine peso, hongkong dollar.
Or, perhaps that input can be in local currenly but the final tally will be computing in us$.
Can you pls help me out on this as what i am doing currently is putting the local currencly divided by a cell in which it refers to the conversion rate like i will typre in a cell say 800 (chinese rmb) will be =800/L48 , where L48 is 8 (1us$ = 8 rmb). Then on another type of expense i may put 500 (phil peso) like =500/L47 , where L47 is 52 (1us$ = 52 peso).
So it is very tediuous to input expenses in this way. Any help to make inputting easier?
Thanks.
Start Free Trial
