currency convertor issue

further to donkeyotes post there is xml.get.cell in the more functions addin
http://download.cnet.com/Morefunc/30...-10423159.html
used as =XLM.GET.CELL(7,A1)
it would return [$$-409]#,##0.00
for usd and
[$€-83C]#,##0.00 euro (irish)

You could manipulate the "format" of the cell and use that

12	=CELL("format",A1)
12	=CELL("format",A2)
	
=IF(CELL("format",A1)=",2",A1*4,A1*5)	
=IF(CELL("format",A2)=",2",A2*4,A2*5)

where Cell format A1 = number with 2 decimals and
where Cell format A2 = $ #,##0.00;$ #,##0.00

I don't think that would work (in all scenarios) given it would be dependent upon client locale.

For ex. this works for you because € is default system currency thus cells formatted as Euro's return a cell format of C# (where # is determined by decimals used) whereas all other currencies return ,#, however, in the UK given £ is default system currency both Euro and USD would return ,# and only £ would return C#

Also given # you would probably want to revise the approach to check only for existence of C in format given the no. of decimals may vary.

(If the client is set to use $ as system currency then (reversed) it could work of course)