Basic query on PRODUCT function...

J

Joe Pettersson

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
 
D

daddylonglegs

=PRODUCT(E5:H5)

will multiply all cells in the range, i.e. it will multiply E5 by F5 b
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*H
 
J

Joe Pettersson

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

Jo
 
Top