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

=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

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

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

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