Hi there,

This is interesting. When I add the Currency Symbol to the equation, it loses the round function. i.e.:

=VLOOKUP($D$2,$H$6:$I$13,2,FALSE)&" "&IF($D$2="USA Dollar",1,(ROUND(D7*(VLOOKUP($D$2&" to US Dollar",$T$5:$V$46,3,FALSE)),2)))

This will return the symbol with the converted amount; however, there are times when the amount will come back:

¥ 782.3 instead of ¥ 782.30

Any ideas???


Thank you,
RG