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