Multiply several columns by Paramater

by Jon Hurley   Last Updated September 11, 2019 17:01 PM

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



Answers 1


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:

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

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

Gary's Student
Gary's Student
September 11, 2019 16:58 PM

Related Questions


Updated December 08, 2015 09:00 AM

Updated January 15, 2019 18:01 PM

Updated April 28, 2017 18:01 PM

Updated May 25, 2018 23:01 PM

Updated December 17, 2018 15:01 PM