Basic query on PRODUCT function...
 

Hi,
I'm having trouble multuplying values in different columns, I've
experimented with the PRODUCT function, but it doesn't work well. I
need to create a function that will multiply a value in Column E with a
Value in Column H and for the result to show up in Column I. I've used
the Product function to do this (and produced this code, for instance:
=PRODUCT(E5:H5) [produced in column I for example]), but the problem is
that if the value of H is zero then the value of E shows up in the I
cell automantically and I don't want that to happen, do you have any
ideas how to stop this showing up? also, I want to apply the same
formula to the whole document so that It doesn't just happen in one row
at a time, is there any way of doing this without having to re-enter the
code individually for each row?

Thanks, any help whatsoever would be appreciated, and thanks once
again!

Joe


--
Joe Pettersson
------------------------------------------------------------------------
Joe Pettersson's Profile: http://www.excelforum.com/member.php...o&userid=37196
View this thread: http://www.excelforum.com/showthread...hreadid=569069

Basic query on PRODUCT function...
 

=PRODUCT(E5:H5)

will multiply all cells in the range, i.e. it will multiply E5 by F5 by
G5 by H5.

If you want to multiply just E5 by H5

=PRODUCT(E5,H5)

or, if you expect E5 and H5 to be numeric, just use

=E5*H5


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=569069

Basic query on PRODUCT function...
 

Hi, thanks for that, the =E5*H5 worker perfectly... is there anyway that
I can get that to apply down the length of the whole column? so I don't
have to type =E6*H6, =E7*H7, =E8*H8, for example, for each row? becasue
its quite along documet...again thanks for your help, and any help on
this problem would be appreciated...

Joe


--
Joe Pettersson
------------------------------------------------------------------------
Joe Pettersson's Profile: http://www.excelforum.com/member.php...o&userid=37196
View this thread: http://www.excelforum.com/showthread...hreadid=569069

Basic query on PRODUCT function...
 

You can use the Fill Handle to copy to adjacent cells. There's a picture
and instructions he

http://www.contextures.com/xlDataEntry01.html#Mouse

Joe Pettersson wrote:
Hi, thanks for that, the =E5*H5 worker perfectly... is there anyway that
I can get that to apply down the length of the whole column? so I don't
have to type =E6*H6, =E7*H7, =E8*H8, for example, for each row? becasue
its quite along documet...again thanks for your help, and any help on
this problem would be appreciated...

Joe




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html