0

I have a set of budgeted columns - Jan, Feb, Mar, etc will sales values in a Foreign currency. I want to multiply all monthly columns by a FX rate enter via a Parameter. It this possible?

I know I could add a new column for the FX rate and then add additional columns to multiply each month by the FX value, but was hoping for a short cut.

Regards, Jon

New contributor
Jon Hurley is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • 1
    What have you tried so far? Is it really that time consuming? – cybernetic.nomad Sep 11 at 16:53
0

If FX is the same for all columns and all cells within the columns, then you can rely of the distributive property to keep the equation simple. Say the raw values are in A1 through A10, C1 through C10 and G1 through G10. Put the conversion factor in cell Z100 (for example) and then use:

=Z100*(SUM(A1:A10)+SUM(C1:C10)+SUM(G1:G10))

You don't have to multiply each cell by the factor.

0

Do you want to permanently convert the values to the new ones, or to keep them as they are but also show them in another currency?

If you want to permanently convert them, type your exchange rate in a cell. Copy. Select all the values and use Paste Special > Multiply

Your Answer

Jon Hurley is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.