Error: requires that all monetary values use the same currency

Hi 'Bill,

Change the format of cells containing currency amounts to 'number' with two decimal places. Use separate columns for each currency, or use a second column to indicate the currency being used. If you take the second choice, and you intend to do any calculations with the amounts, you will need a column in which to collect the values, converted to a common unit.

Regards,

Barry

Hi He.Bill,

Input table with a column for each currency

A Header Row with the name of the currency. Body Cells are Number format. Footer Row shows the SUM of each currency.

Formula in Footer Cell A6 (and Fill Right)

=SUM(A)

You can add more rows to that table, and the SUM formulas will automatically adjust

Next table where you input the today's exchange rate (imaginary values, because they change daily). The world standard is the USA Dollar, so that is always 1.00

No formulas in that table.

Next table converts the sums for each currency to US$

Formula in A2 (and Fill Right)

=Input::A6×'Exchange rates to US$'::A2

Now SUM all the values to get a total in US$

Regards,

Ian.

Hi He.Bill,

Would you post a screenshot of the cell with the formula in it and the referenced cells?

quinn