Product of 3 Cells based on criteria

[aileen]

I have 6 columns of data as such:

A B C D E F
150 0 0 P .55 250
0 325 0 C 1.60 50
0 0 35 F .77 100

In the G column,I need to get the product of columns A,E,F if D = P and the
product of B,E,F if D = C and the product of C,E,F if D = F. Is this
possible? Any help is always appreciated. Thanks.

 

[Bernard Liengme]

Could be done with nested IFs but this works
=(A1*(D1="P")+B1*(D1="C")+C1*(D1="F"))*E1*F1
You want E*F*(A if..., or B if ..., or C if...)

best wishes

 

[aileen]

Works perfectly. Thanks much!

Could be done with nested IFs but this works
=(A1*(D1="P")+B1*(D1="C")+C1*(D1="F"))*E1*F1
You want E*F*(A if..., or B if ..., or C if...)

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email