Calculate cells based on multiple criteria

[jealkon]

Trying to calculate cells based on multiple criteria and have run into a block. I've attached the file as well as copied it here.
Using Excel 2003
If columnD=Billable and column E is not #N/A, multiply column C by column G

Project Name Total Time User 2 Team Dept Rates
Project1 User1 116.00 BILLABLE CS_BA B06 $76.50
Project2 User2 5.00 BILLABLE CS_BA BB9 $76.50
Project3 User3 21.50 BILLABLE CS_PMO BD2 $92.75
Project4 User4 3.50 BILLABLE CS_PMO BD2 $76.50
Project5 User5 1.00 BILLABLE Acct_Mgmt B06 $76.50
Project6 User6 31.00 BILLABLE CS_PMO BD2 $76.50
Project7 User7 13.50 BILLABLE CS_PMO BD2 $92.75
Project8 User8 0.75 BILLABLE Acct_Mgmt B06 $92.75
Project9 User9 5.40 BILLABLE CS_BA BB9 $92.75
Project10 User10 3.50 BILLABLE #N/A #N/A $92.75
Project11 User11 1.00 BILLABLE #N/A #N/A $76.50