[diegogo]

Don't know that it has those kinds of formatting conditions. Probably your best bet is to do it the stupid way. So your A column would be amount, B column would be currency, C would be exchange rate to shekels, D would be amount in shekels, etc.

Added bonus is that this is database import-friendly and doesn't lend itself to inadvertently getting figures losing currency context due to formatting changes (happens surprisingly frequently in my line of work). Anybody gives you grief on doing it the stupid way, just say that you're planning ahead.

Good luck.