Hi All,
I have been spinning around in circles trying to make a workable solution to this - I am sure the Excel experts out there will know how.
I have a starting number of say £50,000. This is the opening balance. I want to show this in Euros and US $ too. Easy enough with a simple formula.
Now I want to show a running balance as debits come off the opening balance - leaving a running total.
However, the debits can be in three currencies - Euro, US $ and Sterling.
So I want the spreadsheet to calculate the balance regardless of which currency is being debited from the opening balance.
So if the o/b is £50,000 - and a payment of $10,000 is made - I want the result to be £43,806.52 in the running total.
$10,000 converted to Sterling at 1.6146 exchange rate giving £6193.48 and then deducted from the total.
Simple enough - but the debit could be one of three currencies - which is where I am struggling.
Any help or suggestions would be great.
Bookmarks