Ok. I C. There will only be numerical values in any of the cells with the
exception of a NA# value, because the lookup didn't produce any results in
that colmn. I will try this and C if it works.

thank you,

Candi

"Pete_UK" wrote:

You don't seem to be using the values from column F and H in your
description.

Try this formula in I2:

=IF(OR(D2="",D2="NA",G2="",G2="NA"),0,IF(OR(E2="", E2="NA"),D2*G2,IF
(ISNUMBER(E2),E2,"not defined")))

You can see that you have not been very precise in your description -
what happens if you have other text values in those cells?

Hope this helps.

Pete

On May 5, 5:04 pm, 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?