Sum If - I think
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?
|