try this
=IF(ISERROR(OR(E2="",D2="",G2="")),0,IF(E20,E2,D2 *G2))

Does this do what you want?
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"CandiC" wrote:

I have a worksheet with data in Columns D, E, F, G, and H that I will use to
calculate column I. If E2 contains a numeric value, then transfer that value
to I2, but if E2 is Blank or NA then use the product of (D2*G2), if colums
D2, E2, G2 are blank or NA then return the value of zero.

Can someone please help?