Multiplying an Entire Range by a fixed number

**ppisklak** · 12-15-2011, 01:02 PM

I have a named range called "Right1" that has several thousand values.

I am trying to use an AverageIF formula using this cell.

I want to average only those that are at least 25% lower than another value, which is in cell B153.

Right now I have =AverageIF(Right1,Right1/B$153 "<0.75")

It tells me the formula has an error.

Any suggestions?

**NBVC** · 12-15-2011, 01:19 PM

Maybe?

=Averageif(Right1,"<="&B153*0.75)

or

=Averageif(Right1,">="&B153*0.75)

not sure which way you want...

**optomyst** · 12-15-2011, 01:25 PM

See attached file.... you needed a column to compare your % of difference evaluation. change numbers in the yellow box to see how this works.

Optomyst