Hi

I need help with Excel 2007

This is the sample data:

A1 B1 C1 D1
100 0 1
400 1 1
500 1 0
200 0 0

Scenario 1: If B1=0 And C1=1 then calculate D1 as a percentage of A1
Scenario 2: If B1=1 and C1=1 then D1=0
Scenario 3: If B1=1 And C1=0 then D1=0
Scenario 3: If both B1 and C1=0 then D1=0

NB: B AND C ARE ALWAYS EITHER 1 OR 0

How do i build the function to perform these calculations in column D
dependant on the values in B and C?