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