Multiplying Values only less than 1.5
Hi,
I have a column of cells that are using if() and vlookup() to pull numbers from elsewhere. I need excel to, in a separate cell, multiply all of the values from these cells that are less than 1.5. But some of the values are greater than 1.5, and I need those not to be a part of the multiplication. Any help would be appreciated.
-AC
|