Thanks, Clancy

I have looked at the spreadsheet and realise that the IFs are unnecessary: so I have removed them. I have no idea why I put them in in the first place.
However, it makes no difference. Nor does changing currency or to number. The calculation is the calculation: the currency plays no part and is only an add-on (probably a bit of coding that concatenates the symbol and the arithmetic answer).

So I am still hoping for ideas.

Thanks

Richard