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.
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. Save 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:
You don't have to multiply each cell by the factor.