Put this in E3
=IF(OR(D3="G",D3="S"),"",IF(D3="A",C3*E2,"Not equal to G or S or A"))

Replace "Not equal to G or S or A" with what you want in that situation.

"George" wrote:

Excel 2007
In a cost spreed sheet I need to set up a formula that will allow me to
change one cell to effect three different cells;
If D3 = A, then E3 = the sum of C3 x E2, if D3 = G or S, then E3 must remain
blank