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.