Ifs ands & ors

[pablo1]

I am trying to write a formula that will select a cell value if the following conditions are met.

If cell E2 is more than or equal to the value in cell A2 and also no greater than the value of cell C2 the the value of D2 is copied into cell E3. If E2 is less than A2 or more than C2 then 0 is shown in E3.

Hope you can help

Pablo 1

 

[xld]

=if(and(e2>=a2,<=c2),d2,0)

 

[Scott Huish]

=and(e2>=a2,e2<=c2)*d2

 

[pablo1]

Thanks very much for your help; a colleague and I spent hours on it and you sorted it in no time

Pablo1