View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sorrywm
 
Posts: n/a
Default Multiply currency

I am trying to convert a value in BHD to $. I have the amount in Currency,
BHD, in A1, and I have the type set as Currency, $ in A2. I am typing this
formula into A2: =A1*2.65. But I get ##VALUE!##, instead of an amount. Why
can I not multiply with currency?