[ic] UPS shipping and converting currencies

[Scott Goodman]

Hi,

I have set up a store which bills in US dollars, but ships from Canada. 
I have the UPS lookups working correctly, but the rate tables  for 
shipping from Canada are in Canadian dollars. Is it possible to apply a 
formula to the shipping amount  returned by a UPS lookup so that I can 
convert the shipping cost to the equivalent is US dollars? It seems I 
can use either a formula or a UPS lookup, but not both.

Thanks for any help!
Scott Goodman