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.