Amanda Kenner Amanda Kenner is offline

Junior Member

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiplying values in columns	Ach	New Users to Excel	2	December 1st 09 02:16 AM
multiplying	wineforyou	Excel Worksheet Functions	5	November 15th 09 05:35 PM
Multiplying Contiguous Values in an Array	[email protected]	Excel Worksheet Functions	1	May 26th 07 06:46 AM
Multiplying cell values	Kalanen	Excel Discussion (Misc queries)	2	May 25th 07 08:56 AM
Multiplying time values and numbers	bunnyc	Excel Discussion (Misc queries)	3	February 17th 06 03:43 PM

All times are GMT +1. The time now is 02:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us