1 Reply Latest reply: Nov 9, 2013 3:02 AM by ziceva
Jan-Peter Onstwedder Level 1 Level 1 (15 points)

I need to add values in different currencies, obviously after converting all of them into a common currency. Numbers version 2 allowed me to add a cell formatted in GBP to a cell formatted in USD, with the latter multiplied by the exchange rate. Numbers 3 doesn't allow this anymore: it will only add cells formatted in the same currency. It's an infuriating attempt to be helpful...But how do I get around this silly limitation?

 

Jan-Peter


Numbers 3.0, OS X Mavericks (10.9)
  • ziceva Level 1 Level 1 (10 points)

    I found a workaround ... What I do is apply the truncate function and it also strips the currency ...

    So, if A1 cell has $ currency, B1 has € currency and C1 has the exchange rate (automatic format), in D1 you could do:

    =truncate(A1,2)*C1+truncate(B1,2)

    You can apply the € currency to D1 ...